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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If you are using Accdb files then there is no replication facility available.
You would have to write it all yourself.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JorgenConsultantAuthor 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.