Replica Set has Exceeded Maximum Number of Day message

[spectraflame]

I am new to Access so excuse my ignorance.

I have a DB that is giving me this error. It is asking to Delete the replica set member and create a new replica.

First I do not understand the need for creating this replica. Second I do not understand the process on how to create the replica.

Is there a way to just disable the replica creation all together and just run the DB as is?

 

[Joe4]

I have never seen or heard of such a message, and it returns no hits in a Google search.
Are you sure it isn't some sort of custom programmed message, either from your system or from the database (via VBA)?
Does the error message box look like an Access message box? Any title or clues in it of where it might be coming from?

 

[spectraflame]

It is a standalone DB and appears to me to be a default Access message. Not sure how to check to see if there is some VBAncode in the back. It was developed in 2006. Thinking it may be related to opening it up in Access 2016 however I am getting same message when opening it up in version 2010.

I have never seen or heard of such a message, and it returns no hits in a Google search.
Are you sure it isn't some sort of custom programmed message, either from your system or from the database (via VBA)?
Does the error message box look like an Access message box? Any title or clues in it of where it might be coming from?

 

[Joe4]

Do you still see that error when you bypass Startup Options (see: https://support.office.com/en-us/ar...tabase-71a7403b-881a-46f0-a807-8c9218cc2ef7)?
If not, then the error is probably some sort of Custom Error message created in VBA code by some programmer, and is not anything native to Access.
Perhaps the user has programmed something to check a certain condition, and warn you.

Try to search for the word "replica" in the VB code. You can do this by:
- Opening the database
- Hitting ALT-F11 to open the VB Editor
- Hitting CTRL-F to bring up the Find search box
- Enter the word "replica" in the Find box
- Select the "Current Project" radio button
- Click the "Find Next" button

See if it finds that error message in the VB code.

 

[spectraflame]

Could I just export the tables, queries, forms etc. To a new DB. Will review your suggestions in the morning.

Do you still see that error when you bypass Startup Options (see: https://support.office.com/en-us/ar...tabase-71a7403b-881a-46f0-a807-8c9218cc2ef7)?
If not, then the error is probably some sort of Custom Error message created in VBA code by some programmer, and is not anything native to Access.
Perhaps the user has programmed something to check a certain condition, and warn you.

Try to search for the word "replica" in the VB code. You can do this by:
- Opening the database
- Hitting ALT-F11 to open the VB Editor
- Hitting CTRL-F to bring up the Find search box
- Enter the word "replica" in the Find box
- Select the "Current Project" radio button
- Click the "Find Next" button

See if it finds that error message in the VB code.

 

[Joe4]

Could I just export the tables, queries, forms etc. To a new DB. Will review your suggestions in the morning.

Why? Are you unable to open the database? Even if you try bypassing the start-up options, as-described in that link?

It is possible that importing the objects may or may not make that message disappear, but I think you might want to know why it is happening and what it means.

 

[spectraflame]

No VB Code found. I am still able to open the DB however since there is only a single user of the DB I see no need to replicate it.

Why? Are you unable to open the database? Even if you try bypassing the start-up options, as-described in that link?

It is possible that importing the objects may or may not make that message disappear, but I think you might want to know why it is happening and what it means.