Synchronizing changes between multiple Access databases

I've noticed that Access 2010 (maybe earlier also) - can prepera database for replication, and is able to synchronize changes beetween specified databases.

My question is - is it possible to call this function from 开发者_开发技巧Visual Studio , using C# ? if yes - then how ?

For a central starting point for Jet Replication, see my Jet Replication Wiki.

However, keep in mind:

1. replication is a Jet technology, and is available only in MDB format, not in ACCDB (though you can have an ACCDB front end with tables linked to a replicated MDB back end).

2. Jet replication works only across a networked connection, or an occasionally networked connection.

For programmatic synchronization, you can use DAO or JRO. DAO is recommended because it is Jet's native interface library, but it lacks the ability to initiate an indirect synch (a type of synch that is safe across unreliable connections, i.e., anything other than a WIRED LAN). JRO provides that, but there is virtually nothing else in JRO that is of any value.

If you're using OLEDB, then JRO is the natural choice, though.

Microsoft has effectively deprecated Jet replication for quite some time now. The preferred technology for synchronizing Access/Jet/ACE databases now is Sharepoint. Now that Sharepoint 2010 supports referential integrity and the performance problems with large lists has been eliminated, I would not recommend Jet replication except for the simplest scenario, i.e., disconnected laptop users who visit the home office and plug into the wired LAN there.

Anything else, I'd recommend against Jet replication.