Updateing records from one table to an ather.

[jboss1995]

I have a master database with tables only on a shared folder. Each user has a database on their laptop with local tables and linked tables to the master database. When they are off the network they edit the local tables on the database but when the laptop is back on the net work it needs to update to the master database. The master database should reflect the same data as all clients databases. I have done this with vb code but have seen some anomalies with data integrity. I would like to do this with a orthodox way using a query. Basically the query would update any changes and add any additions from one table to another. I do not mind if it has to be two queries.



Thanks.

[RuralGuy]

Have you looked into replication?

[jboss1995]

Have you looked into replication?

No, never heard of it.

[RuralGuy]

I'm not an expert on it but ac2003 supports it (but not ac2007) and was designed for the situation you are describing.

[jboss1995]

I'm not an expert on it but ac2003 supports it (but not ac2007) and was designed for the situation you are describing.

Is it in access help file, or is there a better place to look?

[RuralGuy]

Google is your friend. Here's a start:
http://office.microsoft.com/en-us/ac...526841033.aspx

[jboss1995]

Google is your friend. Here's a start:
http://office.microsoft.com/en-us/ac...526841033.aspx

Thanks I will give it a try.