Shutdown after inactivity (create extra form?)

[John J.]

I'm trying to implement the automatic 'after inactivity' shutdown using the
code from: http://support.microsoft.com/?id=210297.

The first action that is described in the article is:
"1. Create a blank form that is not based on any table or query and name it
DetectIdleTime."

In my app I already have a main menu form which is always open and is not
based on any table or query. However, in the form's open, there's code that
opens a persistant connection (recordset variable) to a small backend table
as described in http://www.accessmvp.com/TWickerath/articles/multiuser.htm.

My question is, can I safely use my main menu form as the DetectIdleTime
form or should I make an extra new form?

Thanks,
John

 

[Dirk Goldgar]

I'm trying to implement the automatic 'after inactivity' shutdown using
the code from: http://support.microsoft.com/?id=210297.

The first action that is described in the article is:
"1. Create a blank form that is not based on any table or query and name
it DetectIdleTime."

In my app I already have a main menu form which is always open and is not
based on any table or query. However, in the form's open, there's code
that opens a persistant connection (recordset variable) to a small backend
table as described in
http://www.accessmvp.com/TWickerath/articles/multiuser.htm.

My question is, can I safely use my main menu form as the DetectIdleTime
form or should I make an extra new form?

Yes, you can use your existing form.

 

[John J.]

Will do so. Thank you.
John

Yes, you can use your existing form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[a a r o n _ k e m p f]

this is not possible using Jet.

but if you use SQL Server, this is not a problem-- because you don't
have to kick people out of the back end so you can take a backup, or
run a script, etc

 

[Tony Toews [MVP]]

this is not possible using Jet.

This statement is wrong.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/