By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Autoclose a database (or access) after a certain amount of time

P: n/a
Is there anyway to make a database close after it has been open and
idle for a specified time? I have to do updates once in a while on a
company database, and a few people have a habit of leaving it open all
the time (and breaking that habit isn't working too well).

Generally it is left open to the switchboard, not on an open, mid-edit
form or report. So losing saved information isn't a concern in most
cases.

Possibilities?

-Rick

Feb 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,
Is there anyway to make a database close after it has been open and
idle for a specified time? I have to do updates once in a while on a
company database, and a few people have a habit of leaving it open all
the time (and breaking that habit isn't working too well).

Generally it is left open to the switchboard, not on an open, mid-edit
form or report. So losing saved information isn't a concern in most
cases.

Possibilities?
There's a sample ( Detect and Logoff Idle Users ) on :

http://www.candace-tripp.com/pages/a...downloads.aspx

Regards
Jens


Feb 6 '07 #2

P: n/a
That site is awesome. Thanks. Can't believe that hasn't come up in
my previous searches.

On Feb 6, 12:48 pm, "Jens Schilling"
<JensSchillingBitteLoesc...@fissership.dewrote:
Hi,
Is there anyway to make a database close after it has been open and
idle for a specified time? I have to do updates once in a while on a
company database, and a few people have a habit of leaving it open all
the time (and breaking that habit isn't working too well).
Generally it is left open to the switchboard, not on an open, mid-edit
form or report. So losing saved information isn't a concern in most
cases.
Possibilities?

There's a sample ( Detect and Logoff Idle Users ) on :

http://www.candace-tripp.com/pages/a...downloads.aspx

Regards
Jens

Feb 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.