Could not lock file message

[humph]

Hi folks - need some help with what is probably very easy but I just can't get it.

I am running an access database on a 2 pc network with shared access etc. I can see all files on both computers but when I try to open the same file on both systems I get error message " could not lock file" I had another database earlier this year working on the two machines perfectly and was able to input data from both and the file was not a froint end back end structiure.

also if is any help the second machine only seems to be able to open in Read only mode. I have tried the user permission on the my computer allow shared access but this has not fixed it.

Any ideas much appreciated

Thanks

Humph

 

[grnzbra]

We had a similar problem here. People were given read only access to a folder containing an Access database. Any time one of them would go into the database, because they didn't have write access, an .ldb couldn't be created so Access just locked everyone else out, no matter what right they had to the folder. We had to give all of them read-write access.

 

[Tezcatlipoca]

Not to sound trite, but you might also want to double check that the actual database MDB file isn't currently set to 'Read Only'.