Code to automate synchronization of Access 2000 databases

[ferretwoman]

I have one replication of a database sitting on my web server, with the master sitting on another server. I want to sync them up every time the master db is closed. Can anyone give me some sample code to make this happen automatically. And *where* do I put this code? Is it a problem that the master is passworded?

Thanks from an access 2000 newbie!

 

[kwatai]

currentdb.Synchronize strDbName, dbRepImpExpChanges

the above code will sync the local db and the remotedb(strDbName being the path) when executed. Its vb so you have to put it in the module. To run it automatically, just plug it in a form that gets loaded automatically at the beginning... if not, then have it called by autoexec in the macros. Oh, and the code is what i believe DAO, if that means anything to you.