Auto Close Access at 9:00 pm

[bconner]

I have an Access database that is on a shared drive that multiple users maybe logged into. I need an event that will auto close access at 9:00 pm each night. From what I understand I need to have a hidden form that will constantly check the time against 9:00 pm and when it reaches 9:00 pm then Application.Close... Can someone help me write the code for this I have the concept but just can't figure out how to translate it into code...any help is greatly appreciated.

 

[Mr. B]

Attached is a small demo 2003 database file that should be what you are looking for.

Take a look and if you have questions, just post back.

 

[bconner]

Mr. B that is exactly what I am looking for, you are a life saver, thank you Sir!

 

[Mr. B]

You are quite welcom. Good luck with your project.

 

[osotek]

I was just wondering where the attachment was. Do they expire? Because I could not find it.