ACC97: DB Doesn't Close and Reopen After Failed Synchronization
ID: Q164785
|
The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
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.
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.
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.
REFERENCES
For information about a related issue in Microsoft Access 97, please see
the following article in the Microsoft Knowledge Base:
Q164784 ACC97: Unable to Remove Deleted Replica from Synchronize
List
Keywords : kbusage RplConf RplGen
Version : 97
Platform : WINDOWS
Issue type : kbprb