Hi,
 I have an ASP page which acces to an ACCESS database
It was working perfectly since I change a little bit my database,
I only add new fields and create some new joins between new tables tables. Now when I want to do change to the database from my asp page it tell:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only

But my connection is NOT readonly it is :
objRS.Open "BoardTable", strConnect, adOpenStatic, adLockOptimistic, adCmdTable


I did'nt change anything to my asp page, only new tables and joins in my database and the fields that I use in my ASP page haven't change to.

Please help me, it was working perfectly and now I don't understand anything

Thanks a lot

Johnjohn

Let's say the name of your db is "your_db.mdb" - then look for a file called "your_db.ldb" in the same folder - if it's there, delete it! It's a lock on the db.

Thank you but I know that and check it and it's ok...

Ok...
Assuming fileperms are ok too: Try running your INSERT/UPDATE-statement from within Access. Ie. Copy/Paste it into the SQL-window of a new view. See if Access gives you some error - it's probably a question of referential integrity...

Is this resolved?

Yes, it was a security issue but I really don't know how come it change by itself but anyway it's working now thanks Jonax