merging access data between multiple computers

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

How does one export data from an access db on one computer
to merge it with (add to) the access data on an identical
access db on a different computer.
 
Append queries are probably the simplest way if your goal is to combine te
data. Linked tables if you just want it to be visible from one to the
other.
 
Right.
Whe you use Append queries and you get to the screen where you name a table:
STOP.

There is an option to choose another database!
(I can't tell you how many users don't see this!)

Click it and enter the path to the other .mdb.
Then pick the table in the other mdb!
 
Back
Top