Problem with “Cannot update. Database or object is read-only.”

[AnilNe]

Dear Friends,
I got a online application where through ASP pages, data entered by web site visitor is to be inserted into the database.

Whenever data is inserted it gives error message “Cannot update. Database or object is read-only.” I have given write permission to MDB file through IIS. Also I have checked the mdb file from explorer if it is read only file. But still I have same problem. I am confused if I have missed any step.

Any help will be highly appreciated.

Thanks in advance.

With Regards,
Anil

 

[Veep]

The IUSR_MachineName account needs the permissions. If you need help with that just ask.

 

[AnilNe]

Ya please give me some help regarding this.
I have checked "Anonymous Access" and checked "Allow IIS to control password".

Do i need to do something specific in this case?

Your kind help will be appreciated.

With regards,
Anil

 

[Veep]

Right-click on the folder that the database is in.
Select Properties from the context menu.
Select the Security tab.
Click Add.
Find the user entry that starts with IUSR_
It will be IUSR_ + Whatever the machine name is.
Add that user and give him write permissions.
That should solve the problem.

 

[DreXor]

PS ... you did the permissions _IN_ IIS, you need to do them on the system side, OUTSIDE IIS, as in use windows explorer to get to the folder, right click, then security / permissions iusr needs to have change permissions (including delete ) for MS db's

IIS's permissions/security settings can be a little misleading sometimes.

DreX
aKa - Robert

 

[AnilNe]

Ya please give me some help regarding this.
I have checked "Anonymous Access" and checked "Allow IIS to control password".

Do i need to do something specific in this case?

Your kind help will be appreciated.

With regards,
Anil

 

[AnilNe]

Dear Friends,
Thank you for your help.
I did everything as you have suggested.
However, I am still having problem with “Permission Denied”.
I am really so much frustrated with this.
Kindly please help me.

Thanks in advance.

With Regards,
Anil

 

[DreXor]

also, just in case, perhaps try a refresh ... you might have the error cached.

DreX
aKa - Robert

 

[Veep]

Like DreXor said, get out of IIS and set the permission using Windows Explorer. If after setting the permissions correctly it still doesn't work, check the properties of the database (.mdb) file. It may just be Read-Only.

 

[DreXor]

also, you cant access the db if you or someone else has it open in access, you cannot view data in access and asp at the same time, unless you're using some indepth group settings.

if per chance the machine has suddenly shutdown or rebooted or locked while using the DB in access, the .ldb file wont get cleared and leave the db locked in a read only state as well. make sure this file isn't present in the same folder your db resides. if it is, you might have a hard time deleting it, if you can delete it, you should be ok to get things running again.

and lastly, only other that comes to mind about being read only, is settings inside of access to lock the deb, or make the data read only, including password settings etc. on the actual database from inside.

DreX
aKa - Robert

 

[newmediaguy]

System Security Policies can over ride the manual change on both the folder and Db [both need to be set to allow Iusr_xxx] to read/write access.

If you arent logged in as the admin on the server or a security policy set through the server disallows it then you need to speak to them to grant that privelige.

hope this helps....



Glen
Conception | Execution

 

[lunesis]

try it

http://support.microsoft.com/defaul...port/kb/articles/Q175/1/68.ASP&NoWebContent=1

u must to give write permission to the system's temp folder (that one in the environment variables list)