views:

43

answers:

1

i have about 20 users who have their own access front end and write to a backend.

i need to do an update to the backend, and every time i try to do it offhours, it seems that someone is still logged on because the file is locked!

how do i get around this? i do tell the users to log off at the end of the day but a lot of them forget! is there a way to force them off?

can i disconnect someone from an access database?

+2  A: 

Idle Detect/Inactivity Timeout

How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access

I don't expect any points for my answer as Remou already gave you these. But whenever reasonable I prefer to give pages with links to the official KB articles rather thwn who knows how mangled up code can get in a forum. Including this one.

Tony Toews