how do i synch some tables in two databases -not always connected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a client that uses access to enter "observations" into a table.
sometimes they are new observations, sometimes updates. The main db resides
on a network share and can be used and updated while he is out making
observations but the observation tables are not touched except by him. When
he returns to the office, he wants to update his observations with a press of
the button.

I can export the tables to a file on the server, then import it into the
database as a temporary table and do an update query from there but it seems
as though there must be a less kludgey way to do this.
 
Back
Top