By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

Combine 2 versions of the same database

P: 1
How can I combine 2 versions of the same database without losing or duplicating data?
We have a periodicals checkin database at the Library. A user copied the database to the desktop instead of adding a shortcut. Now we have twor versions of the database, both incomplete. How can they be combined w/o losing or duplicating data?
Aug 14 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Best to import the table(s) from the desktop version in the other database.
You'll see that the new tablename will be the old one appended by a "1".
Now go into the query editor and create an append query fom this "1" version to the original.
One problem might occur, when you have an autonumber as uunique key, then make sure that the append query doesn't include the autonumber field !!!
After the append was successfull, remove the "1" version of the tables.

Always make first a backup of both databases, just to be sure !

Aug 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.