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.
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/
__________________________________________
> 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.
Is there any other user permissions setting besides on the db itself and on
the folder that I need to look at?
> 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/
> 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?