Repair/update database

[raja07]

I have a question that has been fraustrating me for some time. how do i force
users out of my database to perform maintenance? short of literally forcing
them out that is i'd like to be able to close the application so that i can
make updates etc. folks leave at the end of the day and leave the application
open and i have to hunt them down to close the application by which time
other people jump in; so fraustrating. any suggestions on work-arounds would
be extremely helpful. thanks a bunch!

 

[Douglas J. Steele]

Take a look at http://support.microsoft.com/kb/210297

Hopefully your application is 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: every user should have his/her own copy of the front-end, ideally on
his/her hard drive. If that's not the way your application is, it should be.

 

[Tom van Stiphout]

On Tue, 13 Nov 2007 06:14:11 -0800, raja07

In addition to what Doug said: you can write some code in the timer
event of a (potentially hidden) form to once a minute inspect a value
in some table. If that value indicates "Shut Down", it will do so. Of
course you'll want to be graceful about that.

-Tom.

 

[raja07]

this works perfectly! thank you so much for saving me days, weeks of
fraustration

 

[raja07]

that's a great thought, thanks for letting me know. we actually sat around
trying to come up with the most ungracious things to pop up prior to quitting
the application but i think we'll be "graceful". this is so exciting; i just
passed the code around for everyone in my group now they're excited