Can I use JRO with .Net?

I have a replicated Access Database that I will need to be able to synchronize.  I know that Access using JRO to manage the synchronization.  Am I able to use JRO with .NET.  If not, can anyone point me in the right direction to find some material to explain how to handle the synchronization.

On a side note, what I am doing is rebuilding the frontend of the application to get it out of Access.  I don't necessarily have to use Access as a backend.  What I do have to do is make the data accessable on and off the network.  Most of the time it will be used in the office; however, the application will need to be able to run on several laptops at remote locations where they will not have access to the internet.  I will need to insure the data's integrity and have some way to synchronize the information when the laptops are back on the network.

Currently, I was looking for a solution that would keep the same backend.  If someone knows how to accomplish this using a different backend and can help me personally or point me to the information I will need to come up with a working solution I will also accept that.

Thank you,
Kevin McBrearty
LVL 3
kmcbreartyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed NasmanSoftware DeveloperCommented:
This article uses JRO to compact and repair Access, it may help you to accomplish what you are looking for
http://www.thecodeproject.com/cs/database/mdbcompact_latebind.asp
0
kmcbreartyAuthor Commented:
Sorry,

mnasman that really isn't helping me.

Kevin
0
kmcbreartyAuthor Commented:
mnasman,

I have created code using VB.NET.  The following is the VB.NET code that was used and works.  

-----------------------------------------------------------------------------------------------------------------------------------------------
Imports System
Imports System.Windows.Forms
Imports JRO
Imports JRO.SyncTypeEnum
Imports JRO.SyncModeEnum


Module JROSync

    Function Synchronize(ByVal DB1 As String, ByVal DB2 As String)

        Call TwoWayDirectSync(DB1, DB2)

    End Function

    Sub TwoWayDirectSync(ByVal strReplica1 As String, _
    ByVal strReplica2 As String)
        Dim repReplica As New JRO.Replica
        Dim DBConnection As ADODB.Connection
        Dim strDBConnection As String

        Try
            ' Open connection
            strDBConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strReplica1 & ";"
            DBConnection = New ADODB.Connection
            DBConnection.Open(strDBConnection)

            repReplica.ActiveConnection = DBConnection

            ' Sends changes made in each replica to the other.
            repReplica.Synchronize(strReplica2, jrSyncTypeImpExp, jrSyncModeDirect)

            repReplica = Nothing
            MessageBox.Show("Synchronization Complete", "Synchronize Database", MessageBoxButtons.OK, MessageBoxIcon.Information)
        Catch ex As Exception
            MessageBox.Show(ex.Message, "An Error has Occured", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            DBConnection.Close()
            DBConnection = Nothing
        End Try

    End Sub

End Module
-----------------------------------------------------------------------------------------------------------------------------------------------

You have to add a reference to your project to the Microsoft Jet and Replication objects 2.6 library for it work.  If you want to rewrite this code for C# I will go ahead and award you the points.  Otherwise, I recommend that the points be refunded as the above link did not answer the question, it only works for compacting a database which is not what I wanted to accomplish.  I apologize for just now getting back to this but my wife was having some health problems and I haven't had much time to work on it.
0
PAQ_ManCommented:
PAQed with points refunded (500)

PAQ_Man
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

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.