M
mirandatech
I have a databse which is my master and then i created a replcia in another
server i want to synchronize them at night so that they both keep th same
info. I need a macro or a module that can do this so that i can schedule it
so it can run at night or a batch file that would do it. Or do i have to like
copy the whole database becaus ethis can't be done. I had amodule before
that worked for access 97 but it doesn;t work now. it was like this:
Sub TwoWayExchangeX()
Dim DBSMISINFO As Database
Set DBSMISINFO = OpenDatabase("\\KtcClw1\DATA\MIS\ACCESS\MISINFO.mdb")
' Sends changes made in each replica to the other.
DBSMISINFO.SYNCHRONIZE "\\KtcMia1\DATA\MIS\ACCESS\MISINFO.mdb", _
dbRepImpExpChanges
DBSMISINFO.Close
End Sub
Rem ****************** SYNCHRONIZING DATABASE **********************
Rem ****************** PLEASE DON'T DISTURB **********************
server i want to synchronize them at night so that they both keep th same
info. I need a macro or a module that can do this so that i can schedule it
so it can run at night or a batch file that would do it. Or do i have to like
copy the whole database becaus ethis can't be done. I had amodule before
that worked for access 97 but it doesn;t work now. it was like this:
Sub TwoWayExchangeX()
Dim DBSMISINFO As Database
Set DBSMISINFO = OpenDatabase("\\KtcClw1\DATA\MIS\ACCESS\MISINFO.mdb")
' Sends changes made in each replica to the other.
DBSMISINFO.SYNCHRONIZE "\\KtcMia1\DATA\MIS\ACCESS\MISINFO.mdb", _
dbRepImpExpChanges
DBSMISINFO.Close
End Sub
Rem ****************** SYNCHRONIZING DATABASE **********************
Rem ****************** PLEASE DON'T DISTURB **********************