How can I replicate an Access 2010 database similar to way I did with my Access 2002 database?
Posted on 2012-09-20
I have an Access 2002 database (the Design Master) stored on my computer, that is currently replicated (using replication manager 4.0) to 10 other computers.
We have purchased many new computers that include Access 2010. If I convert the Access 2002 database to Access 2010 database, is there anything I need to do differently to replicate the database to the other 10 computers. (Note: I have read that replication has been done away with in Access 2010).
If replication is not available with Access 2010, can I just have 1 copy of the database on the Server, and allow 10 users to open it simultaneously? If so, can I have a security feature that says, if you are user 1, you can open it in Design Master mode, all others, "non-Design Master mode".
The bottom line is this: I want to store the database on 10 computers, allow each user to make changes to the "data" only, then sync with each other for "updates". What is the simplest way to achieve this?
Thank you for your help.