Closing database automatically

[2624]

Hi All,

I want to my database closes automatically every night at 12:00am. The database locates at the Agency Server. If somebody forgets to log off from the database, it fails to back up. Is it posibble to close it by itself?

Any help is as always greatly appreciated.

Seda

 

[jbehrne]

Hi,

Try this link:

It will close all open forms.

http://www.mvps.org/access/forms/frm0040.htm

Once the forms are closed you should be able to close the db using this statement:

DoCmd.quit

If you combine it with this you should be able to build what you want:

http://www.mvps.org/access/modules/mdl0042.htm

Hope this helps,

jbehrne