Microsoft KB Archive/170595

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:04, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

ODE97: Correct Syntax for Internet Synchronization Using DAO

Article ID: 170595

Article Last Modified on 1/20/2007


  • Microsoft Access 97 Standard Edition
  • Microsoft Office 97 Developer Edition

This article was previously published under Q170595

Advanced: Requires expert coding, interoperability, and multiuser skills.


This article demonstrates how to synchronize database replicas over the Internet using data access objects (DAO). This article assumes you have already installed and configured Microsoft Replication Manager on your Internet server to synchronize replicas over the Internet.

For more information about configuring Replication Manager on your Internet server, search the Microsoft ODE Tools Help Index for "Replication Manager, Internet or intranet servers."

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access 97" manual.


You can use Synchronize method of DAO for synchronizing database replicas. The Synchronize method uses the following syntax:

   <database object>.Synchronize pathname, [exchange]

When synchronizing replicas over a local area network, you must specify the local area network path of the replica you want to synchronize with for the pathname argument. When synchronizing replicas over the Internet, you must specify the Uniform Resource Locator (URL) address of the Internet server for the pathname argument, instead of specifying a local area network path. In addition, you must specify the dbRepSyncInternet constant for the exchange argument.

When supplying the URL address of the Internet server, your code does not need to supply the full path to the replica on the server. For instance, if your Internet server name is "MyServer" and contains a replica named "Northwind.mdb" in a shared "Scripts" folder, you would use the syntax:

    Sub SyncReplicas()
       Dim db As Database
       Set db = CurrentDb()
       db.Synchronize "http://MyServer", dbRepSyncInternet
    End Sub

NOTE: Synchronization is bidirectional by default. For more control over the direction of the exchange, you can add one of the other exchange constants (dbRepImportChanges or dbRepExportChanges) to the constant dbRepSyncInternet. For example:

   db.Synchronize "<http://MyServer", dbRepSyncInternet + dbRepExportChanges


For more information about the Synchronize method, search the Help Index for "Synchronize method," or ask the Microsoft Access 97 Office Assistant.

For more information about synchronizing replicas over the Internet, please refer to the Microsoft Jet 3.5 Replication White Paper. See the following article in the Microsoft Knowledge Base for instructions on obtaining the Microsoft Jet 3.5 Replication White Paper:

164553 ACC97: Jet 3.5 Replication White Paper Available in Download Center

Keywords: kbhowto KB170595