Combining duplicate tables w/ different data

T

TTVG

We have a tracking system setup on the network and one of
the users performed a local save to their computer and
have been working off of the same database as the rest of
the staff, therefore I have two copies of the same
database and one of the tables contains different
information than the other. Is there a way to combine
the tables from the two databases, all of the tables
contain the same columns. Any assistance is greatly
appreciated!!!!
 
D

Duane Hookom

You might be able to link to the tables from one to the other and perform
append queries. This all depends on your use of autonumber fields, if you
have set integrity between tables, and other factors.
 

Ask a Question

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.

Ask a Question

Similar Threads

Access ID 3
Combining two tables with respect to corresponding records' individual data cells 0
query field to display results of fields from 2 different tables 1
Merging two tables. 5
Combining Tables from Different Databases 6
combining two databases 4
same field in more than one table 2
too many tables? 3

Top