Log in

View Full Version : Access replication



OTWarrior
01-19-2011, 03:29 AM
I have just stumbled upon this:

http://office.microsoft.com/en-us/access-help/create-a-replicated-database-mdb-HP003069833.aspx

Which talks about replicating an Access Database than using a Frontend/backend system.

Has anyone here used this? If so are there any benefits/problems with using this as a system?

I am hoping it would be faster as I am assuming it would bring the data locally, but I am cautious about unique ID's being duplicated across different copies (replicas) of the database being used.

hansup
01-19-2011, 10:41 AM
Your poll question requires a Yes or No answer. There is no provision for "it depends".

If you haven't already found it, you may appreciate this link to David Fenton's Jet Replication Wiki.

http://www.dfenton.com/DFA/Replication/index.php?title=Main_Page

CreganTur
01-19-2011, 11:23 AM
Replication can work very well, especially when it comes to having to update the code in the parent for error fixing. As for performance... I have no idea.