My network database tells users its read only when it isnt.why?

[MK05]

THis happens even when the users groups allow both read and write?the network
runs on microsoft small business server. Any possible solutions to my
problem??

 

[Jeff Boldig via AccessMonster.com]

I've run into this on several occations. It happens when the user has
read/write permissions for the front end database, but only read permission
to the back end data.

The only solution I've been able to come up with is to put both the front
and back end databases in folders which the users have read and write
permissions for. I then password protect the back end if it isn't already.
This prevents the users from accessing the back end directly. You will
have to delete and relink the tables in the front end using the new
password.

 

[Billie Dee]

In order to affect the data in an access database, the user must have
read/write permissions on it. This includes the backend. The system
creates the .ldb file when the database is open.

I hope that helps.
Billie Dee

 

[Joan Wild]

In order to affect the data in an access database, the user must have
read/write permissions on it. This includes the backend. The system
creates the .ldb file when the database is open.

Which is why users also need create/delete permissions on the folder, in
order to create/delete the ldb file.

Joan Wild
MS Access MVP