I am working on a number of projects that are to be used by a number of people across the network. I have split the code and the tables into separate files and linked the the tables into the code file so that program changes can be made away from site without interfering with the data. Each time I try to link to the database on the server from an ordinary users login I get an error saying that the file is in exclusive use by someone else or I do not have the correct permissions. ( I have set the user up with all the permissions they could need, without making them an administrator )

Can anyone help this multi-user bit seems to be a bit of a black art!

Regards

Mikef

There are several possibilities. The first place I would look is the Advanced tab of the Tools/Options dialog. There you will find the "Default Record Locking" and "Default Open Mode" settings. The "Default Open Mode" should be set to "Shared". I would recommend the "Edited Record" lock for "Default Record Locking".

For more information, look in the on-line help. Go the "Find" tab and enter "exclusive". You will find a bevy of hits.

I would also check with your network admin that Access databases are not opened exclusivly by default.

alun

Another option you could do - which does tend to come in handy - is have a function that copies the front end to the user's local hard drive, then opens it there. This way, the front end on the network isn't actually used, so it doesn't matter if it's opened exclusive or not. Also if you need to make changes to the design of the database, you make them on the one on your local drive, then copy it up to the network. Then the next time that anyone opens the database, it opens it with the changes.


There are 10 kinds of people in the world - those who understand binary - and those with friends