How to update original database with data entered in the backup co

  • Thread starter Thread starter Amit Patel
  • Start date Start date
A

Amit Patel

I have 2 x copies of same access 2003 database, one is Master database copy
and other is Backup copy. By mistake we have entered data into the backup
copy with latest records. Now we would like to update the original copy of
database with the data entered into the backup copy of the database.
We tried to use "REPLICATION" option from tools menu but this asks to make a
replica database first from the main database. Can we use existing backup
database as a "Replica" database and the master copy as "Design Master"
database? If not the is there any way to update the latest changes from the
backup database to the master copy?
 
First, make "backup" copies of both, since you'll be trying to make "bulk"
data updates.

You can open the Master database to the database window and "link" to the
tables in the other copy.

Then create queries that return the values you wish to update with. When
that's working, you can convert the query(ies) to Update queries that affect
your Master db tables.

Did I mention creating backups before you start?!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top