add a linked table to the master database (the one you plan to keep) that
links back to the others. Then create an append query to grab all the
records from that linked table and insert them into your new master table.
Then, delete the links and delete the unneeeded files.
Rick's suggestion is right on - but just a warning! If your tables
have Autonumber fields, there may - nay, WILL - be conflicts where you
have the same autonumber value (perhaps linked to Long Integer foreign
key fields in other tables) in both or all three databases. You'll
need to come up with some *SAFE* logical way to resolve these
conflicts. This might be easy and it might be nightmarishly difficult
depending on your database structure and how far the autonumber-based
relationships penetrate.
You'll need to give us some help here, DJJohn. What is in these three
mdb files? How many tables? Do the tables have Autonumber fields
(makes a big difference)? How are the tables related?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
