Read Only error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database whichworks fine when the first user enters, but any
subsequent user is told that they can only open the database as read only.

I think the network security setting are correct.

Any suggestions?
 
What are the network security settings?

Each user requires at least Read, Write and eXecute on the folder where the
database exists. (It's usual, but not mandatory, to give them Delete on the
folder as well)
 
Each user has modify/read/list/write...

Douglas J. Steele said:
What are the network security settings?

Each user requires at least Read, Write and eXecute on the folder where the
database exists. (It's usual, but not mandatory, to give them Delete on the
folder as well)
Click to expand...
 
In
JP Jones said:
Each user has modify/read/list/write...
Click to expand...

I think they must have create-file and delete privileges on the folder
as well, or Access won't be able to create (and later delete) the LDB
file that permits shared write access.
 
Dirk Goldgar said:
In

I think they must have create-file and delete privileges on the folder as
well, or Access won't be able to create (and later delete) the LDB file
that permits shared write access.
Click to expand...

I keep forgetting that security has gotten a lot more granular. I've also
heard of issues where both users have the ability to create files (so that
either can create the LDB file), but not to write to files that others have
created. They'll run into the same issue, since Access won't be able to use
the existing LDB file, and cannot create a new one since one already exists.
 
In
Douglas J. Steele said:
I've
also heard of issues where both users have the ability to create
files (so that either can create the LDB file), but not to write to
files that others have created. They'll run into the same issue,
since Access won't be able to use the existing LDB file, and cannot
create a new one since one already exists.
Click to expand...

Yikes, what a mess! I say, just give users full control of the folder
and let it go at that.
 
Back
Top