Discussion Locked
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 attiev
The question was auto-closed by TechRepublic
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.
by attiev
The question was auto-closed by TechRepublic
by attiev
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question Unanswered
How can developers improve performance on content-heavy websites?
0 helpful
0 replies
Question Unanswered
How do you protect downloadable files on a WordPress store?
0 helpful
0 replies