automatic time out

  • Thread starter Thread starter E
  • Start date Start date
E

E

I have a multi user Access 200 application running on our network. i have a
problem with users leaving the application open (inactive). There are times
I'd like to do some maintenance, compact and repair, etc. but the application
is locked. Is there a way to lg off the user after a period of inactivity?
 
Yes you can, but it requires two things before you can even think about doing
it.
1. The database has to be split
2. Each user must have his own copy installed on his computer.

An overview of the technique:

You application needs a form that opens when the application opens. It can
be a hidden form but it must stay open as long as the app is running.
You need a table in the back end database has a field that will indicate
whether the applicaiton is available or not. It is also a good idea to
inlcude a message field so you can warn users the system is coming down soon.

The form should have this table as it's record source and it should be the
start up form. If you currently have a start up form, this form can open it
when it determines it is okay to start up the application. You use the
form's Timer event to periodically refresh the data and check to see if it
needs to shut down. You will also want to use the form's Load event to see
if the system is available and either open the main form or warn the user and
quit.
 
Back
Top