Close Database at 2 A.M Saturday

[Guest]

Multi user database and multi user computers. Someone is always walking away
and leaving database open over the weekend. Database is set to compact and
repair on close. 11PM Friday to 7AM Saturday no crew is working. Windows task
scheduler is not avaliable due to company restrictions. Looked at how to log
users off after a certain amount of idle time however many of the forms that
are open automatically refresh and are open for extended periods of time
without "use", other than viewing updated information. Suggestions on how to
automatically close database would be appreciated. Thanks

 

[Danny J. Lesandrini]

I recently published an article at DBJ on this subject. Nothing in my article that hasn't
been suggested on this newsgroup, but there is a download that will help you see how
it might be implemented ... and a nice "You're being logged off" form that you can
import into your app. That will save you a few minutes work

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

 

[Van T. Dinh]

I haven't used Arvin Meyer's KickThemOff2K so I am not sure whether this
suits your needs but it is work a try:

http://www.datastrat.com/Download2.htm

 

[Guest]

Thank-you both for the links, I will be able to get things worked out now.
Your help is appreciated. eb1mom

 

[dbahooker]

mdb sucks from a real-world point of view

use SQL Server, MSDE
i mean.. if you care enough to build a database; use a database engine
that WORKS

MSDE is free. it runs like a champ.