• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 613
  • Last Modified:

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
0
mardau
Asked:
mardau
  • 2
  • 2
1 Solution
 
mardauAuthor Commented:
Yeah, I've found this. Cant figure out what is that JRO and where to get it ?
0
 
peakpeakCommented:
0
 
mardauAuthor Commented:
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);
0
 
ee_autoCommented:
Question PAQ'd and stored in the solution database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now