Disable database for backup

[adenwalker]

Somewhere i saw a post which described how to disable a database.

Basically when i clicked disable in one database, it stopped other users from accessing another and displayed a message (Database disbaled).

Can anyone help as i need this desperatly.
Thanks

 

[ColinEssex]

Its not quite what you want but sometimes I don't allow users into a database when I'm doing amendments etc.

I have a table with one field (status) which is either "open" or "closed"

Then when the switchboard form is loaded, I have some code that checks the value of the status table. If its "closed" then a MsgBox pops up and says " Closed - try again later" sort of thing, then exits the database. It suits my needs as it stops users using forms I may be working on.

Incidentally, it checks the network name of the users too and if its my name it skips that code to allow me to get in.

Col

 

[adenwalker]

could you post me a sample database or something to help me to do this?

 

[ColinEssex]

what ver of Access are you using?

Col

 

[adenwalker]

access version 2000