We have numerious databases we use and have found that there are some computers that when they open a database up and without accessing anything in it will lock out everone else but if other users open the data base up they dont lock eveyone else out.

We run a variety of operating systems on our comps but there is no consistancy when you look at the comps concerned.

The version database is 2000

If a user that dose not lock the database up opens it first then the user that locks it up other users can then also open it up.

I would apprecite any help with this Thanks in advance.

David.

It is possible to open a db in *exclusive* mode rather than shared mode. It is a system property so it remains with Access rather than following a particular mdb. In acXP it is located in Tools>Options...>Advanced tab on the right.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"