asked on 9/13/2010

Synchronizing changes between multiple Access databases

Hi,

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 ?
access.png

Microsoft Access

Last Comment

ee_auto

7/9/2011

peakpeak

9/13/2010

Yes, you can:
http://office.microsoft.com/en-ca/access-help/methods-and-properties-used-to-programmatically-replicate-a-database-mdb-HP003069832.aspx

mardau

9/13/2010

ASKER

Yeah, I've found this. Cant figure out what is that JRO and where to get it ?

peakpeak

9/13/2010

Use DAO instead, not C# though but VBA.
Or use this tool:
http://sqlhost.codeplex.com/wikipage?title=Database%20Publishing%20Wizard&referringTitle=Home&ProjectName=sqlhost

mardau

9/13/2010

ASKER

Why not C# ?

from the first look, looks like it's working

var a = new JRO.ReplicaClass();

var s =
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source={0};" +
"Jet OLEDB:Database password={1}",
Application.StartupPath + "\\Co2.mdb", "");

//var con = new Connection() { ConnectionString = s };
try
{

a.MakeReplicable(s, true);

ASKER CERTIFIED SOLUTION

ee_auto

7/9/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial