Whilst working my way merrily through ‘Beginning Active Server Pages 3.0” I have hit a problem at Chapter 14. Instead of adding a new record to my movies database, my AddNew.asp code keeps coming up with the same error message –

"HTTP 500.100 Internal Server Error ASP Error IIS
Microsoft Jet Database Engine cannot update. Database or object is Read-Only"

IIS seems to think that my movies database is ‘read-only’ - but it isn't!

I have checked movie2000.mdb – it is not set as a read-only file.
It is located in the root of my c: drive
The ADO connection properties reports that Movie2000.mdb is not read-only.
I deleted and reloaded the database in case of gremlins!! – still no luck.

Finally I have downloaded the code for AddNew.asp from the wrox website in case I have made a typing error which I can’t readily spot. Still the same error message keeps coming back!

Any help and advice gratefully received!!

Grateful thanks to PGTIPS & John Reeve41 - with your help the problem is solved!

Cheers

Pete

Hi,

Pete

 Since you are using MS Access database that's why this type problem arises. Because in ms-access, database architecture used is file system. In this architecture while opening the database a log file is created and on closing the database that log file deleted.

Therefore in this case make the folder which contains the .mdb file must have the read write and delete permission. Try this; I hope this will definitely resolve your problem.

  :)
Best of luck

Surendra Parashar
Gurgaon,
http://www.geocities.com/surendraparashar

Yeah, for anyone else having this issue and reading this thread for the solution, the poster above me is likely correct. This was probably a permissions issue with the folder in which the Access DB resides.