Our Access 2000 database is used by 3 people in our office. One of them has a bad habit -- foretting to log off the network and the database when finished working.
PROBLEM:
Is there an easy way to get Access to do the following:
1. Track when there is over 30 minutes of idle time.
2. Automatically save the current record.
3. Automatically exit the database.
POSSIBLE SOLUTIONS:
I tried using the TimerInterval (in Forms) property, but that is good for only 1 minute maximum. It did automatically close the database after 1 minute of inactivity using the OnDirty event procedure for a new record.
I also tried the technique "Set a maximum locking interval for a record" (Chapter 10, Section10 of O'Reilly's "Access Cookbook")
PROBLEM:
Is there an easy way to get Access to do the following:
1. Track when there is over 30 minutes of idle time.
2. Automatically save the current record.
3. Automatically exit the database.
POSSIBLE SOLUTIONS:
I tried using the TimerInterval (in Forms) property, but that is good for only 1 minute maximum. It did automatically close the database after 1 minute of inactivity using the OnDirty event procedure for a new record.
I also tried the technique "Set a maximum locking interval for a record" (Chapter 10, Section10 of O'Reilly's "Access Cookbook")