Combining 2 databases - access 2.0

[kamur]

Hello,

We have access 2.0 as database for one of our small applications. Say the database name is AOAD.MDB. Now we have two sets of groups needing to update the same database. But the two groups are in different location. We cannot have a common link between the groups. So, on a day, both groups have a same copy of AOAD.MDB . Now group1 will update on their local copy of aoad.mdb and group2 will update on their local copy of aoad.mdb. Now the updates will not include any common tables/data. (if group1 updates table1, group2 will not update table1. Updates will be exclusive)

My requirement is to combine both the local copies of the database , and produce one combine AOAD.MDB having both the updates. How can I do this? If you could provide samples also, it would be great as I am a beginner to access databases.

Thanks and regards
Kamur

 

[KenReay]

Hi

If the two groups NEVER update the same records, you could do it with an Append queries, after all all you need to do is to join the two databases together each day

If it is not as simple as this, and the two groups can update the same records/tables, then you need replication.

Although I have used Access2.0 some years ago, I cannot remember if replication is availble/and works in Access 2.0, can you upgrade to leter version?
Hope this helps

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use