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?
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note that earlier versions of Access supported replication (those in the .mdb format). Also, SQL Server Express supports replication. SSE is free and integrates very nicely with Access.
If you are using Accdb files then there is no replication facility available.
You would have to write it all yourself.
JorgenAuthor Commented:
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.


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.