Cannot update. Database or object is read-only - User rights?!

[roithi]

Hi together.

I have a problem getting this error message "Cannot update. Database or object is read-only" in my Access form application.

The funny thing is, when i run this program under a Administrator account, it's working...but its not working with the User account.

Of course the User hast permission to this folder, it's just a folder on the "C:" drive.

Is there a special right i have to modify that the user can work on it?

thanks

thomas

 

[Dennisk]

when you refer to administrator and user are you referring to Access workgroup accounts if so then your user account does not have the required permissions for the form.

 

[roithi]

I'm talking about Windows Administrator and User.

When i log onto my computer as Admin i can Access the Form

when i login as a restricted User on my PC i cannot access the form

 

[The_Doc_Man]

In order to open an Access database you must be able to open the file for MODIFY. You must also be able to create the .LDB file that is the run-time lock file. Sounds to me like your user account doesn't have the required permissions.

 

[roithi]

I know that i might be a problem with the user permission... Do you know the name of the right which i need to give the user?

 

[roithi]

ok...i found a solution

I changed the account from user to poweruser... now its working ;-)

 

[The_Doc_Man]

In general, on the "Security" properties page, the MODIFY setting is what you need. If you went to the Advanced page, you need everything except the stuff that lets you set the file's security and ownership. I believe that if you select MODIFY on the non-advanced page and take notes on the advanced page, then go back and change that to FULL CONTROL, go advanced and take notes again, the difference is the list of advanced things you DON'T need.

Just remember, if you have ANY permissions marked as DENY, you are screwed. Because just like "awshits" and "attaboys" - one DENY cancels a thousand ALLOWs.