Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Synchronizing changes between multiple Access databases

Posted on 2010-09-13
6
Medium Priority
?
603 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
5 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

572 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