Quit access if inactive

[gaj104]

Hi,

Is it possible to have a code running in the background which will quit access if the specific database is not being used.

I have made an exclusive database and if people forget to quit out then it will automatically exit after a period of x mins of inactivity.

Many thanks

 

[SydneyGeek]

Graeme, this can be done with a form that is ALWAYS open -- such as a menu form, or a hidden form that opens when the database launches.

Let's say you have a hidden form called frmScan, with an unbound textbox called txtTime.

In the form's Load event, you need the one-liner
txtTime=0

In the OnTime event you need
txtTime = txtTime + 1
If txtTime >=20 Then
DoCmd.Quit
End If
(this will quit after 20 minutes -- change to suit)

In the TimerInterval property put 60000 (that's 60 seconds -- TimerInterval works in milliseconds).

OK, at the moment the DB will spontaneously shut after 20 minutes. What you need in the BeforeUpdate event of EACH data entry form is this:
Forms!frmScan!txtTime = 0
This resets txtTime every time you save a record. So, if you keep using the DB it will stay open. When you go away for lunch or a meeting, it will close.

Denis

 

[VicRauch]

I just wanted to ask the obvious question. Why have a database that only one person can use at a time? Why not let multiple users on at the same time?

 

[gaj104]

I just wanted to ask the obvious question. Why have a database that only one person can use at a time? Why not let multiple users on at the same time?

Hi Vic,

The database queries another database which the user determines the date, and the resultant table is used to create a variety of reports and queries.

It therefore is impractible for multiple users to change the date if another user is using a different date as the generated dynamic table contains around 70,000 rows.

Hi, SyndneyGeek

Thanks for the reply, I like the logic behind your idea. The only query I had on it was that the user will not be updating records per say, only running queries and pressing buttons (as everything is automated). Will the same principle work?

Many thanks

 

[sam slade]

gaj104,

i think what sydneygeek is getting at is the hidden form routine will reset itself WHEN any action is performed, whether a query is run or switch between controls. not just the saving of records.

Hope this helps.

 

[SydneyGeek]

Yep, the idea will work for any activity, as long as you trap it.

I had it set to work on saved records, but you could attach the code to the Click event of any button, for instance.

Denis