Replicating ODBC database

[mur3x]

Hi i found the following code in MSDN where Jet Replication is used to sysnchronize between two Access databases. I want to use ODBC connection for the second database (FY96.mdb).i want to know how can i use this code with a ODBC connection.

Sub JROTwoWayDirectSync()

   Dim repMaster As New JRO.Replica

   repMaster.ActiveConnection = ".\NorthWind.mdb"

   ' Sends changes made in each replica to the other.

   repMaster.Synchronize ".\FY96.mdb", jrSyncTypeImpExp, _
      jrSyncModeDirect

   Set repMaster = Nothing

End Sub

thanks...
Mur.

 

[LostInCode]

Just curious: Why do you want to use ODBC for a Jet mdb instead of using jet directly?

 

[mur3x]

Thnx for your reply. No i want replicate a SQL server Database and a Access database. I want to create a DSN for the SQl server database and replicate it thru the Access Database. Will it be possible..How shud i modify the connection to ODBC?.