Getting Could Not Lock File error message
Rick Young
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
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
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
> 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.
xiaozhou
xiaozhou
xiaozhou
xiaozhou
Rick Young
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
wrote in news:2B840C82-229E-4D68...@microsoft.com:
> 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.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tom Wickerath
> 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?