shared access error 1

[coolgaff]

HI I would be most grateful if anyone could tell me how to get past lock errors when more than 1 person is trying to open a database on the network. All shared defaults are set in options but when ever one person has it open and a second person tries to open it we get thefile is locked cannot open. Could not lock table "sbs" currently in use by user Admin on machine ***.

any ideas?

 

[ClemsonSeth]

Under the Tools menu, choose Options, then the Advanced. Make sure that the default open mode is set to "shared" not "exclusive".

Also, If any user is working in a table, it can cause problems for other users trying to work on info in that table - so you'll need to make sure that your users are working in forms.

 

[coolgaff]

Hi thanks for this. These settings are as you say. The agents will be working on the form created by us. I created a brand new db with data and then managed to open it on 3 pc's no problem. I then went into security and user and group settings. I then printed screen shots of all the settigns in the working db and then tried to match them with the main db that does not work and still no joy. It seems some sort of lock is stopping it from opening. I would be willing to send the db file as it is currently 4.5mb.last message was the database engine could not lock table "sbs" because it is already in use by another person or process. I need a drink!

 

[brightstar]

make sure the permission for everyone who is trying to open the database is set to "change"
when someone opens the database a record locking file ".ldb" is created.
if anyone else tries to open the database without having change access to this file they will not even be able to get into it at all.

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world

 

[coolgaff]

Hi where do you set the "change" function to allow this to work?

Thanks

 

[brightstar]

its a file permission.
eg you have your database in a folder called "database". everyones permissions on that folder should be change or full control or whatever... as long as they have the permissions they need to be able to add and change files in that dirctory.

obviously when they ooen the database they are going to need "add" permissions to the folder becuase Access will try and create a record locking file ( a .ldb file). I assume they have that much becuase otherwise they wouldnt be able to open the database at all!

now, in order for them to be able to get into the database when someone else is already in it they need to be able to change that .ldb file. (it adds their hostname). If they cannot change that file they cannot get into the database at all and they get that message saying cannot use file already in use etc.

the .ldb file obviously inherits the permissions of its parent folder - so the problem is if the databse folder has permissions set on it so that users can only read the contents they will not be able to change the .ldb file and therefore not be able to enter the database.

it'll be a bit clearer if you go into a database, minimise it, open the .ldb file from that database in notepad and read the contents.

hope this helps

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world