Access 2002: Connecting two databases

[D.M]

I have 2 same databases. First one is the main (central) database located on
personal computer. The second one is secondary database located on mobile
(laptop) computer and its carrying to the other towns.
How connect second (mobile) database to the main database to update data
collected in other towns.
Thanks.

 

[Bonnie]

How about something like this: your mobile database
could have an update option that runs an update query.
(You would have to work out a link to the home table
first.) After linking, run the update query. Of course
this is a simplification - you will have to work out how
not to allow duplicates from the mobile table into the
home table, etc.

 

[Dave Elliott]

Alternatively, you could use Briefcase.

--


---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://[email protected]