Requiring user to re-login periodically

[RussCRM]

I'm using the Access User-Level Security features with various users
set up.

I have a form/timer all set up to trigger an event after a period of
inactivity.

I'd like that event to log off a user and force them to log back in or
to require them to login periodically. The reason for this is that
multiple people use the database and I want to make sure the current
user is the logged in person.

Also, I'd like to configure a button for them to log off when they
walk away from the computer.

On top of that, I'm wondering if this can be done without kicking them
out of the database and having to reload it every time.

 

[Brendan Reynolds]

I'm using the Access User-Level Security features with various users
set up.

I have a form/timer all set up to trigger an event after a period of
inactivity.

I'd like that event to log off a user and force them to log back in or
to require them to login periodically. The reason for this is that
multiple people use the database and I want to make sure the current
user is the logged in person.

Also, I'd like to configure a button for them to log off when they
walk away from the computer.

On top of that, I'm wondering if this can be done without kicking them
out of the database and having to reload it every time.

To the best of my knowledge, no, there is no way to log out without closing
the database. If you want to do that, it's simply DoCmd.CloseDatabase.
You'll need to make very sure that your users really are not currently using
the application and have saved any pending updates, though. And at the end
of the day, will it really accomplish your goal? Doing this may decrease the
probability that the person using the app is not the person who logged in,
but it cannot completely prevent it.

 

[RussCRM]

I tried looking at this but it requires SQL Server 2000 Desktop
Engine, which I can't figure out how to install.