automatically Updating Access Database at night???

[tekvb1977]

Is there a way my access database could get updated automatically at night without me opening up the database and hitting the update command button. I know Access has a scheduler that could do it but I don't know exactly how to use it.

Thanks

J

 

[gavjb]

A very simple way, which will only work as far as i know if you dont use security, is to create a quick form which runs the code of your button on load and then closes the app. you then need to right click on the form and select create shortcut (access will then create an windows shortcut) .

After you have done this you should be able to add the shortcut to windows scheduler with no problems.