Logout

[Guest]

is there a way to force the logout of all open sessions at a schedule time
(before doing backup)

Thanks !

 

[Guest]

Hi Yvan,

Yes this is possible.

Essentially, all you need to do is have a table in the backend for the sole
purpose of determining whether the programme should run or not.

On a timer event in a form that opens at startup and remains open for the
entire session of every front end running, place code similar to the
following:

IF DLookup("Checkfield","ShutdownTbl") = -1 Then
doCmd.Quit
Else
End If

Either manually enter a yes/no value into the shutdown table or do it as an
UPDATE SQL.
That is the basic method of achieving your goal, but, make it a little nicer
by giving a warning before kicking people out of course.

Regards,

Nick

 

[Danny J. Lesandrini]

Yvan:

In addition to code published by many others at this newsgroup,
I have written an article for DBJ about auto-logout. Give it a look
and download the free code.

http://www.databasejournal.com/features/msaccess/article.php/3548586

 

[Arvin Meyer [MVP]]

is there a way to force the logout of all open sessions at a schedule time
(before doing backup)

Have a look at:

http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

That is the basic method of achieving your goal, but, make it a little nicer
by giving a warning before kicking people out of course.

But don't give that warning by using a msgbox. That will halt
execution at that point. Better to display a form with a warning
message and a countdown.

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