need database to close at time interval

[Teresa]

I have a large shared database with about 400 users. (I know, I know ... too
many!) Despite all my nagging about closing the database when not in use, I
continually have users that leave the database open overnight. I would like
to set a timeout event to close the database when it hasn't been touched in
an hour. Can I do that?

 

[John W. Vinson]

I have a large shared database with about 400 users. (I know, I know ... too
many!)

Two is too many.

Run, don't walk, to the Database Splitter Wizard. Each user should have their
own copy of a Frontend containing the forms, reports, etc. linked to a shared
backend.

Despite all my nagging about closing the database when not in use, I
continually have users that leave the database open overnight. I would like
to set a timeout event to close the database when it hasn't been touched in
an hour. Can I do that?

Fix the split first.

 

[Teresa]

OK. I'll research it to figure out how. Thanks.

 

[John W. Vinson]

OK. I'll research it to figure out how. Thanks.

http://www.granite.ab.ca/access/splitapp.htm