Solved

Synchronizing changes between multiple Access databases

Posted on 2010-09-13
6
563 Views
Last Modified: 2012-06-21
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
Comment
Question by:mardau
  • 2
  • 2
6 Comments
 
LVL 28

Expert Comment

by:peakpeak
ID: 33662012
0
 
LVL 2

Author Comment

by:mardau
ID: 33662042
Yeah, I've found this. Cant figure out what is that JRO and where to get it ?
0
 
LVL 28

Expert Comment

by:peakpeak
ID: 33662184
0
 
LVL 2

Author Comment

by:mardau
ID: 33663068
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
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 36157673
Question PAQ'd and stored in the solution database.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question