synchronise data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database in two locations and wish to synchronise the data daily.
what is the best way to do this.

i have also envisaged an issue with auto numbers as both sites if they start
from 1 will then use 2 as the next record, causing a conflict when i try to
synchronise.

any suggestions please...

thanks

richard
 
i use Windows task scheduler that opens a db that does the syncronization and
then closes. I synchronize every half hour.
Create a new db
create a form with this in the on open event changing the file names
Dim dbRemote As DAO.Database


Set dbRemote = DBEngine.OpenDatabase("\\server16\mrs\Yourmaster.mdb")
dbRemote.Synchronize "\\server9\mrs\yourremote.mdb"
Set dbRemote = Nothing
DoCmd.Quit

In the Wiondows task scheduler put
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" C:\synchDBName.mdb
 
Hi Eric,

thanks for this, ill give this a try. any ideas on the possible autonumber
comflicts as users will be using each database in their own location at the
same time.

regards

richard
 
I don't have autonumber problems due to only my master gets new records
added. Try a google search on access replication conflicts.
 
Back
Top