why is my Access database read-only?

P

Patti

I built a database and then saved it out on our shared drive for others to
use. Why are others, when they go in, getting a message stating it's
read-only? I checked the file attributes and "Read Only" is not checked. I
didn't set up any security levels when I built this. What do you think is the
problem?
 
D

Dirk Goldgar

Patti said:
I built a database and then saved it out on our shared drive for
others to use. Why are others, when they go in, getting a message
stating it's read-only? I checked the file attributes and "Read Only"
is not checked. I didn't set up any security levels when I built
this. What do you think is the problem?
Click to expand...

Do the users have full permissions -- including file-create
and -delete -- on the server folder where the database is? They need
those permissions so that Access can create and manage the
record-locking (.ldb) file in that folder.

Are all users going to be opening this same .mdb file directly from the
server? That's not a good way to do it; it can work, but it's prone to
corruption. Better is to split the database into a back-end .mdb file
(containing only the tables) and a front-end file containing all other
objects, with tables linked to those in the back-end. Then put the
back-end on the server and a separate copy of the front-end on each
user's PC.
 
A

aaron.kempf

are you talking about an ACCESS DATA PROJECT?

This is just a known bug in ADP and those assholes won't fix it
 
P

Patti

Thanks so much Dirk. As a novice in this, I really appreciate your help and
will use your advice.
 
Top