The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Replication using MS Access

Hi all, anyone here tried using the replication feature in Access? How reliable is it? Thanks so much in advance.
Toh Yen Cheng Send private email
Tuesday, February 13, 2007
 
 
I used Access/Jet replication for a couple fairly small projects years ago with Access2000.  It worked, but be warned that it's harder to work with than ordinary setup, takes extra planning and development.  Also, it's generally a higher maintenance solution that you should only do if you're absolutely positove that you need it, that you fully understand how replication works, and that in the end a higher-power db like SQL Server isn't going to be better for the job. 

Here's a link to get you going on understanding just how everything works:
http://www.dfenton.com/DFA/Replication/index.php/Resources_for_learning_about_Jet_Replication
Herbert Sitz Send private email
Tuesday, February 13, 2007
 
 
You need to ask yourself if you REALLY need replication before jumping into this. I've seen so many people try to use replication for things that could have been easily accomplished with simple "post and forget" or "nightly batch polling" facilities.

All replication systems are pretty much made for enterprise datacenter applications with a couple of databases that are constantly being watched by a DBA. If you try to put replication out into remote client sites with no one watching it you will end up living a nightmare.

So figure out what you really need to do. For most people, posting some updates in the form of XML or SQL and applying them nightly is more than enough. Given that you are talking about Access it is highly likely that you are in one of these scenarios. After all, people don't use Access in enterprise datacenters.
dood mcdoogle
Tuesday, February 13, 2007
 
 
Keep in mind that replication has now been taken out of MS Access 2007 (to the dismay of many developers).  So don't bother if you foresee upgrading in the future.
ChrisB
Tuesday, February 13, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz