Development issue

[kanjeep]

Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get my updates made on time.

Any ideas?

 

[KenHigg]

One of the better ways I've seen is to create a form timer event that checks a value to see if the system needs to be automatically shut down. Of course it doesn't unless the admin changes the value...

Make sense?

 

[KeithG]

That is one of the advantages to spliting your db into a FE and BE. You can make design changes as you wish and send out updates.