Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Deleted a Table while Synchronizing Databases

Status
Not open for further replies.

JDows

MIS
May 6, 2002
4
US
Hello all.

I have 8 copies of a database that others are collcting data in while I work on the Master file. I made changes yesterday morning and made copies for everyone. Since then I had imported and exported the data from previous versions of the database into a table that was named the same as the original main table (I renamed the old one).


When I came in this morning to sync up the tables, somehow the main table was deleted from 4 of the copies. I did not use the specific Access process to replicate the DB, I just did a copy/paste when I initially created them (not sure if that matters).

Has this happend to anyone? Is there any way to restore the tables? Losing all of yesterday's data would not be good. Please help!
 
Copying a Replication Master and Pasting it to make a replicated copy is perfectly acceptable way to make a rep copy, so that is not your problem.

However if the table is gone - then it is gone.
Unless you have the copy from last night's backup ( you do 'backups' don't you ? )

What state is the Replication Master in ?
Do it contain all of the data or is it a day behind ?






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top