How to create a timeout to throw users out of the database? 4

[PaulCooper]

Hi,

I have a database that has a front end and back end. I have some lazy users who do not log out so an access.LockFile.9 is generated which prevents me from updating the code. (I cannot delete this file ~ says someone is using it, does not say who!) It is a major pain to work around folk to a) find the culprit and b) log them off.

Ideally I would like some code that logs users off after (say) 2 hours inactivity, or if that is difficult, 12 hours after logging on ~ so at least once a day (first thing) the database is available for maintenance.

Any suggestions? Paul

 

[PaulCooper]

Bump: DaOtH ~ any progress? Paul

 

[DaOtH]

Yep, progress being that i am in the last week of my current job, starting with my new employer 1st of oct.
Meaning, i've got a nice week off next week. Will spend some of the valuable free time publishing here.
sorry, but i am overloaded with last bits and pieces and knowledge transfers and all that.

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[PaulCooper]

Bump: DaOtH ~ any progress? Paul