Syncing data between to MDB's

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

Guest

Hi Everyone,
I've been given a small project to import records from a laptop mdb to a mdb
on the server. There has been a few problems so far. The mdb's are using
autonumber for the key field of the parent table. I was having a problem
inserting the data into the server database. I finally changed the Autonumber
to Random and I can now insert into the database using the querys I have. The
but problem is that on the server the key field is changed from the original
value, so I need to get that value back so that I can update the child tables
with the correct key value. Is there a way to do this? I'm using Access 2003
with ADO. Thanks for any help.
Michael Lee
 
Hi Michael,

Are you trying to import records from one database to the other, or to
synchronise two copies of one database, one on a roaming laptop and the
other on the server?

If the latter, you should investigate Access's built-in Replication
feature.
 
Hi John,
Thanks for the reply. The user only wanted the data to be updated to the
server and not back onto the laptop. I thought that replication may be to
much for that. I've come up with something that will work once I get the bugs
out. Once I get the parameterized queries working right I'll have what I
need. Thanks again for you reply.
Michael
 
Back
Top