Opening Exclusively (1 Viewer)

[seany]

I have small problem that I can't get access to edit my own database because the are constantly people using it. So is it possible to kick uses off my database so that I get exclusive to edit it?

Cheers

 

[ScottGem]

I have small problem that I can't get access to edit my own database because the are constantly people using it. So is it possible to kick uses off my database so that I get exclusive to edit it?

Cheers

Yes, but that's not the answer. Your Database should be split between back end (tables) and front end (everything else). You should have a copy of the front end that you use to do your editing. When you are satisfied your changes work, then you replace the production front end with your development copy. This is usually done early or late in the day when people are not using it.

If you need to implement a change immediately, you can use the Detect and Logoff Idle Users app found here: http://www.candace-tripp.com/pages/access_downloads.aspx. or the one here: http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb.