Microsoft KB Archive/164785

= ACC97: Database Does Not Close and Reopen After Failed Synchronization =

Article ID: 164785

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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 ''.

'' 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 ''.

Couldn't find file ''.

This is followed by another message:

  Microsoft Access has deleted '' 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.



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



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



Steps to Reproduce Problem

 * 1) Create a new blank database named dbTest.mdb.
 * 2) On the Tools menu, point to Replication, and then click Create Replica.
 * 3) Click Yes in the message box that states the database must be closed before you can create a replica.
 * 4) Click No in the message box that prompts you to make a backup copy of your database.
 * 5) In the "Location of New Replica" dialog box, select a folder and file name for the new replica, and then click OK.
 * 6) Delete the new replica database using Windows Explorer or File Manager.
 * 7) On the Tools menu, point to Replication, and then click Synchronize Now.
 * 8) 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.

