August 5th, 2004, 03:27 AM
|
|
Registered User
|
|
Join Date: Aug 2002
Location: Bradford , UK
Posts: 13
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
How do I? Programmatic synchronization in Access 2002
I tried looking in the VBA help to programmatically do a DB synchronization, but it doesnt seem to work....I think my help files have got their versions mixed up.
Does anyone know how I can acheive this, basically I am trying in the long run to have a hyperlink on a data access page which will synchronise the database with another.
The help gave me this
Code:
Sub InternetSynchronizeX()
Dim dbsTemp As Database
Set dbsTemp = OpenDatabase("C:\Data\OrdEntry.mdb")
' Synchronize the local database with the replica on
' the Internet server.
dbsTemp.Synchronize _
"www.mycompany.myserver.com" _
& "/files/Orders.mdb", _
dbRepImpExpChanges + dbRepSyncInternet
dbsTemp.Close
End Sub
But VBA for Access 2002 thinks the Dim statement has unrecognised type......
Does anyone know how to programmaticaly induce a synchronisation ???
Thanks
Scott.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
