How to stop a DB without code to make changes?

[Chrisso]

Hi All

I have an Access 2000 DB that many users are logged onto and they dont
log off when they go home. This means I cannot make changes to the DB.
I have seen ways of adding code etc to kick people out but I cannot do
this obviously. How can I kill the DB and kick out all the users. Can
I delete the file if I was the administrator? I need to update the DB
before I go on vacation!

Thanks for any pointers
Chrisso

 

[Douglas J. Steele]

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations). Only the back-end should be on the server: each user
should have his/her own copy of the front-end, ideally on his/her hard
drive.

In that way, you make the changes in your copy of the front-end, and once
you're satisfied that everything's working as it should be, you simply
replace everyone else's copy of the front-end. To make it even easier, Tony
Toews has a free Auto FE updater at
http://www.granite.ab.ca/access/autofe.htm