Discussion Locked

Access Replications

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to schedule replications in access between two servers. It can be done Manually, can one schedule it to run at certain times?

5 replies

by mark.thomson

Try something like this

Create a 3rd .MDB file with an "autoexec" macro that opens a form.

In the form's load event write some vba code that performs the replication you want does some status logging and then exits

write a batch file thatgoes something like

msaccess.exe 3rdmdb.mdb
(you may have to fiddle with the paths here to get this to work but it will work)

schedule your batch file with the NT "AT" command - it is possible to run applications directly with AT but if you schedule a batch file it is easier to make changes

by ktrobee

Microsoft Developer has a utility called Replication Manager 4.0 that automates replication and synchronization. You can manage multiple databases and replicas easily and schedule them to replicate at a certain time and day.

This discussion is closed to new replies.