Auto Close Idle Access Database?

[bmoconn]

I am having a total brain lock and I need some help. I created a database that is used by several people at once on an almost continual basis, and when I need to to an update to it for a change I made I just net send everyone to get out, howver sometimes people walk away and lock their computers and I can't get to it. normally I just copy the file over anyway but I have a seperate database with the tables in it that needs compacting once in a while and I can't do that while anyone is in it. how can I shut the database down after being idle? or can you just boot someone out? thanks.

 

[BobJacksonNCI]

Do some searching here...

Or I'll take two minutes to help:

faq181-2145

forum181

http://securityadmin.info/noframes/faqget.asp#autologoff

And REMEMBER, It's not easy, it's Access!


HTH,
Bob

 

[bmoconn]

Thanks that helps. I may just set up a time when I do regular maintenance, thanks!

 

[BobJacksonNCI]

Oops!

I copied the wrong hotlink (Forum181).

You might want to look at:

faq181-1432

Bob

 

[bmoconn]

Exactly what I needed!!!!! thank you so much!!