[AccessD] Replication

Julie Reardon-Taylor prosoft6 at hotmail.com
Tue Jun 26 09:19:31 CDT 2007


I am using replication and trying to import the records that are on a tablet 
pc.  However, the systems keeps replacing the main database on the server 
when it sychs the two systems.

This is the code.  Where am I going wrong?

Private Sub Command0_Click()

   Dim conn As New ADODB.Connection
   Dim repMaster As New JRO.Replica
   Dim RepSub As New JRO.Replica


conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data 
source=W:\Skylineback.mdb;"

repMaster.ActiveConnection = conn


repMaster.Synchronize "C:\Inspections\SkylineBack.mdb", jrSyncTypeExport, 
jrSyncModeDirect
MsgBox "Synchronization of Replica and Master is complete."

End Sub



Julie Reardon
PRO-SOFT OF NY, INC.
44 Public Square Suite #5
Watertown, NY 13601
Phone: 315.785.0319
Fax: 315.785.0323
www.pro-soft.net
NYS IT Services Contract CMT026A
NYS Certified Woman-Owned Business

_________________________________________________________________
PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows 
Live Hotmail. 
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507




More information about the AccessD mailing list