Microsoft KB Archive/170595

= ODE97: Correct Syntax for Internet Synchronization Using DAO =

Article ID: 170595

Article Last Modified on 1/20/2007

-

APPLIES TO


 * 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.



SUMMARY
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.



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

  .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 "