Article ID: 164784
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q164784
Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
When you try to synchronize with a replica that has been deleted, you may receive the following error message:
This is followed by another message:
Microsoft Access has deleted '<Database Name>' and removed it from the replica set.
This change isn't reflected until the database is closed and reopened.
Do you want Microsoft Access to close and reopen the database now?
However, after you close and reopen the database, the deleted replica name still appears in the Synchronize With list in the Synchronize Database dialog box.
NOTE: Microsoft Access 97 does not automatically close and reopen the database as stated in the message. For more information about this issue, please see the following article in the Microsoft Knowledge Base:
164785 ACC97: DB Doesn't Close and Reopen After Failed Synchronization
RESOLUTION
In order to remove the deleted replica database from the synchronization list, Microsoft Access 97 must be able to locate the folder where the replica once resided. If the folder that contained the replica has been deleted or renamed, recreate the folder or rename it to its original name. Then synchronize with the deleted replica, and Microsoft Access will remove the replica from the synchronization list.
MORE INFORMATION
Steps to Reproduce Behavior
- Create a new blank database named dbTest.mdb.
- On the Tools menu, point to Replication, and then click Create Replica.
- Click Yes in the message box that states the database must be closed before you can create a replica.
- Click No in the message box that prompts you to make a backup copy of your database.
- In the "Location of New Replica" dialog box, click the Create New Folder icon and create a new folder named dbTest Folder. Select that folder in the Save In box, and then click OK.
- Delete the dbTest Folder and its replica using Windows Explorer or File Manager.
- On the Tools menu, point to Replication, and then click Synchronize Now.
- In the Synchronize Database dialog box, select the deleted replica in the Synchronize With box, and then click OK. Note that you receive the error messages listed in the "Symptoms" section.
- Click Cancel in the Synchronize Database dialog box.
- Close and reopen dbTest.mdb.
- On the Tools menu, point to Replication, and then click Synchronize Now. Note that the deleted replica still appears in the Synchronize With box in the Synchronize Database dialog box.
REFERENCES
For information about a related replication issue in Microsoft Access 7.0, please see the following article in the Microsoft Knowledge Base:
164237 ACC95: Deleted Replicas Still Show in Synchronization List
Additional query words: Microsoft Access can t open the database isn t
Keywords: kberrmsg kbprb kbusage KB164784