Getting Could Not Lock File error message

[Rick Young]

I have a single user who is getting 'Could Not Lock File' error mesage when
they open a specific Access 2003 database. The user is running Access 2007.

I checked permissions on the folder where the database lives and on the
datbase itself. The user has write permissions, their permissions match
other users who can open the database. I tested this by having the user
create a text file in that folder, they can create a file. I copied the
database to the same folder and the user can open that copy.

Any suggestions would be appreciated.

 

[Tom Wickerath]

Hi Rick,

Do any other users have this database open when your A2007 user attempts to
open it? If so, are they using a different version of Access?

Has this database been split, and is each user running their own copy of the
"FE" (front-end) application file, that is loaded onto their local hard drive?

Split the Database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Rick Young]

The environment has a mixture of Access 2003 & Access 2007 users.
Other Access 2007 users have no problem getting into this 2003 database.
Other users can log onto this user's machine and they can access the
database (which sounds like a permission issue).

 

[Tom Wickerath]

Hi Rick,

Other users can log onto this user's machine....

Do you have a peer-to-peer network? If so, you will be much better off
purchasing a file server and setting up a proper network. You can likely
acquire a "gently used" (reconditioned) file server from a major vendor for a
huge discount versus purchasing brand new.

The bottom line is that each user *needs* to be running their own copy of a
front-end database application that is linked to a shared back-end (data
only) database. This should be set up on a proper network, with a file
server. Anything else is simply asking for trouble.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[xiaozhou]

The environment has a mixture of Access 2003 & Access 2007 users.
Other Access 2007 users have no problem getting into this 2003 database.
Other users can log onto this user's machine and they can access the
database (which sounds like a permission issue).

 

[xiaozhou]

The environment has a mixture of Access 2003 & Access 2007 users.
Other Access 2007 users have no problem getting into this 2003 database.
Other users can log onto this user's machine and they can access the
database (which sounds like a permission issue).

 

[xiaozhou]

ÎÒÏë²Î¼ÓÌÖÂÛ

The environment has a mixture of Access 2003 & Access 2007 users.
Other Access 2007 users have no problem getting into this 2003 database.
Other users can log onto this user's machine and they can access the
database (which sounds like a permission issue).

 

[xiaozhou]

ÎÒÏë

The environment has a mixture of Access 2003 & Access 2007 users.
Other Access 2007 users have no problem getting into this 2003 database.
Other users can log onto this user's machine and they can access the
database (which sounds like a permission issue).

 

[Rick Young]

That sounds like a good long-term solution but in the meantime, I've got an
Access 2007 user that can't open the Access 2003 db while other Access 2007
and Access 2003 users can. Telling them (the Sheriff's Office in our county)
that the fix is to re-engineer their business process won't go over well.

Is there any other user permissions setting besides on the db itself and on
the folder that I need to look at?

 

[David W. Fenton]

Is there any other user permissions setting besides on the db
itself and on the folder that I need to look at?

Yes. You need to set permissions not just on the FOLDER but on the
SHARE. The permissions on the two are independent and both need to
be set correctly.

 

[Tom Wickerath]

Hi Rick,

Is there any other user permissions setting besides on the db itself and on
the folder that I need to look at?

Not that I am aware of. You've already verified the write permissions for
this user to the shared folder. Do all Access 2007 users have service pack 2
for Office 2007 installed?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Tom Wickerath]

Hi David,

I think the OP had already established that this part was okay, when he
wrote in his opening post:

"The user has write permissions, their permissions match other users who can
open the database. I tested this by having the user create a text file in
that folder, they can create a file."


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________