Solved

Synchronizing changes between multiple Access databases

Posted on 2010-09-13
6
573 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

617 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