As the Admin Can I lock Access??

[ggodwin]

As an Admin can I lock Access so that users can not use the database for a short period of time? if so what are the steps?

 

[RuralGuy]

The first thing my systems do is set up a persistant connection to my system config table and if I have set a field to a non zero value, the system apologizes and exits. It is part of the Kick 'em Off code. http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

 

[ggodwin]

I just want to preven them from entering while a tweak a couple things..

 

[RuralGuy]

That is called db maintenance and exactly why my systems work the way they do. The message says to try again in a couple of minutes.

 

[boblarson]

I'm hoping that this is the BACKEND of a split database you are talking about. If it is not, or if it is a shared frontend then you really need to rethink your design. It should be split with the copy of the front end on EACH user's computer. The shared part should be the backend (tables only) on the server. Otherwise you are flirting with corruption.

Then updates to the frontend are simple. You make the change and redistribute a new frontend. If you don't want to do that manually you can use my free frontend auto update enabling tool to do it for you:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

 

[RuralGuy]

Real good points Bob. I'm getting too old and slow.

 

[ggodwin]

Bob that is funny you bring this up.
My managment wanted it to all be one little place like you mention. However, because of several problem we are moving it to be tables. I am simply testing the methods that we will use to update the backend tables.

I am just trying to keep everyone out for various "extremely short" un announced test I am doing. Rather than having a scheduled downtime. Most of my test can be done and there would never no I was in there.

I thought there might be a simple "lock" I could apply for a short period..

 

[boblarson]

No "simple" thing fits short of just moving the file to a different location after all are out of the database. Then, they can't access it because it won't be where it would normally be. That would effectively "lock" them out.