AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.

Unattended Sync

Is it possible to set up our server to sync the replica databases on a set schedule (quarterly) without someone personally executing it. We would like to set up our system so that the data is pulled from our network and sent electronically to the state w/o assistance.

Unattended Sync

If you are planning to run the required VBA Code from within a regularly used Database we can write code to cross-check the Sync schedule set in a parameter table and invoke the Sync Program to do the job. You may write the necessary code like the following example for a one way Sync routine or two way Synchronization: