Synchronized Copies of the Same Database

[cpt2014]

Hello,

I was wondering if this is possible.

I have a simple database at the moment which I would like to put onto two laptops. The laptops would be used for entering information when out on a job (no network or email connection).

What I would want to do is have a database on a desktop in the office so when the laptops come back into the office they can update the office database with the information on the laptop database.

Is this possible and how would I go about doing this.

Many Thanks,
Colin

 

[apr pillai]

Database Replication is the feature used for this kind of operations and works only with .MDB Databases.

This feature creates a Master Database and Replicas to take out off-line or install the Master on LAN Server and Replicas on workstations online.

Data changes are done on replicas off-line and synchronized with the Master. Design changes (Forms, Reports, Queries, VBA etc.) are done only on the Master and synchronized with the replicas to update the changes.

Access2007 and later versions don't have this feature.

If you are planning to use this feature try them out on some sample database and learn the procedure and implications properly before implementing it on production database.

 

[cpt2014]

Thanks for your reply

That sounds exactly what I want to do. but only have Access 2010. I tried converting to mbd but it wont let me.

Thanks
Colin