Switchboard that shows "Closed for Maintenance"

[David]

I have a LAN shared database front-end that opens to a switchboard.

How can I make the switchboard display "Closed for Maintenance" and lock all
of the buttons,

Then go back to normal after the maintenance is over?

 

[Brendan Reynolds]

Unless you're still using Access 97 or earlier, you have to open the MDB for
exclusive access to make design changes. When you have it open for exclusive
access, no one else can open it. Therefore, the users will never see your
message.

By far the best solution (in my opinion the only practical solution) is not
to share 'front-end' application MDBs. Each user should have their own local
copy of the application MDB, only the 'back-end' data MDB should be shared.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Douglas J. Steele]

It could be he's talking about doing maintenance on the back-end database
(making table changes, compacting it up or the like).

In that case, if the front-end is connecting to the back-end, it's not going
to be possible to compact it, but it should be possible to "lock" the
front-end while table changes are being made.

I'm at a bit of a disadvantage here, because I never use the built-in
switchboard. I would add a "flag table" with one row in it that indicates
whether or not the database is in Maintenance mode. Have the application
read that table when it starts up, and use that information to display a
"Locked" message when appropriate.

 

[David]

Thanks, I tried that.
It does what I want it to, now I gotta make a button that does turns it on
/off for only
me.