Merge

[rob peterson]

I have a test.mdb. I made a copy copy.mdb.

In the test, we've added many new names to the tables.

In the copy, I've customized the querys, forms and reports but not the
tables.

I want to use the tables in test with the querys, forms and reports in copy.
Which way would be easiest?

 

[tina]

if you want to end up with one database, rather than the two you have now,
suggest you back up the copy.mdb, then delete all the tables from it. then
import the tables from the test.mdb.

or you can do the opposite - back up the test.mdb, then delete all the
objects *except* the tables. then import all the objects *except* the tables
from copy.mdb.

hth

 

[Arvin Meyer [MVP]]

if you want to end up with one database, rather than the two you have now,
suggest you back up the copy.mdb, then delete all the tables from it. then
import the tables from the test.mdb.

or you can do the opposite - back up the test.mdb, then delete all the
objects *except* the tables. then import all the objects *except* the
tables
from copy.mdb.

I'd suggest tina's second choice. That way you do not need to worry about
table relationships. If you do choose the first, make sure in the Import
Dialog Options that Relationships is checked.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com