Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Synchronizing changes between multiple Access databases

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

670 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