ACC97: Database Does Not Close and Reopen After Failed Synchronization

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q164785

Advanced: Requires expert coding, interoperability, and multiuser skills.

SYMPTOMS

After you try to synchronize with a replica that has been deleted, you receive one of the following error messages:

Microsoft Access can't open the database '<Database Name>'.

'<Database Name>' isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

   -or-

Microsoft Access can't open the database '<Database Name>'.

Couldn't find file '<Database Name>'.

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, when you click Yes to close and reopen the database, nothing happens.

Back to the top

CAUSE

Microsoft Access 97 cannot automatically close and reopen the database because the Synchronize Database dialog box is still open.

Back to the top

RESOLUTION

Click Cancel in the Synchronize Database dialog box, and then manually close and reopen the database.

Back to the top

MORE INFORMATION

Steps to Reproduce Problem

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, select a folder and file name for the new replica, and then click OK.
Delete the new replica database 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. When you click Yes to close and reopen the database, nothing happens.

Back to the top

REFERENCES

For information about a related issue in Microsoft Access 97, please see the following article in the Microsoft Knowledge Base:

164784 (http://support.microsoft.com/kb/164784/EN-US/ ) ACC97: Unable to Remove Deleted Replica from Synchronize List

Back to the top

APPLIES TO

Microsoft Access 97 Standard Edition

Back to the top

kbprb kbusage KB164785

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top