Link to home
Start Free TrialLog in
Avatar of Jorgen
JorgenFlag for Denmark

asked on

How to replicate an 2007 MS Access database

Hello everybody

I have an Access database on a server, and needs to have a replica on 3 different computers.

How do I make these replicas in Access 2010?

Is it possible to replicate to a computer, where only Access 2007 is installed?, and can we synchronize data from that computer as well?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

If you are using Accdb files then there is no replication facility available.
You would have to write it all yourself.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jorgen

ASKER

It would have been a great help if any work around on this could be made. For instance ODBC links and update queries that could solve the issue.

regards

Jørgen
Building your own replication strategy involves a LOT more than just update queries. Also, had you replied to the comments we made and asked for further details, we certainly could have tried to point you in the right direction.