Access97 Internet Replication done with VB EXE
We've setup Dos batch files that do Access replication using the
command-line and an Access Autoexec macro to run the below code, which runs fine,
unless there is a problem on one end, then multiple instances of Access remain
open, eventually crashing the machine. The White Paper at q164553 refers to
using DAO in a compiled EXE to do it, but the limited examples do not
actually work, or we cannot get them to work. Does anybody know of better
references on how to code this in VB, or better yet, can it even work? Thanks.
Function ScheduledSynchronize()
Dim servername As String
servername = " http://www.*-*-*.com/ ;
' server is iis4
Dim db As database
Set db = CurrentDb()
db.Synchronize servername, dbRepSyncInternet
End Function