Syncing data between to MDB's

[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

 

[John Nurick]

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.

 

[Guest]

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