I have set up a data synchronisation to 7 other sites that runs from a form. I want to to able to set the synchro to run during the evening to avoid network problems. Is there an easy way to do this?
Any suggestions will be gratefully received
Peter

Here's one method you could do:
If you can set up a macro that will do it, then you're halfway there. (even if it is just a macro that calls some VBA)
Then, all you need to do is create a "Scheduled Task" in Windows, and have it open the file with the macro as a parameter.
Just create a new Scheduled Task that opens Access so that you can get through the wizard, then open the properties, and change it to something like:
The /x switch makes the file run that macro on startup - like an autoexec macro.
Just make sure that you put a Quit command at the end of it so it finishes at the end.

Steven

I am a loud man with a very large hat. This means I am in charge