Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Access database mysteriously became read-only (help!)


Message #1 by "Tim Morgan" <aviatortim@h...> on Tue, 4 Jun 2002 18:30:44
I'm accessing an Access database from my ASP pages via the Microsoft Jet 
OLE-DB driver.  Suddenly the application stopped working and I started 
getting a message that the database was read-only...

Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.

...another page in the application returns a similar message indicating 
that the database isn't updatable...

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.

How do I make the .mdb database file updateable again?

If it helps, the last thing I did before it stopped working was create a 
Workgroup Information File using the Tools>Security>User-Level Security 
Wizard inside Access.  That process asks if you want to create a backup of 
the current file with a .bak extension.  I ended up not using the new 
Workgroup Informaiton File so I changed the .bak extension on the original 
file to .mdb to continue using the original database.  The original file 
appears to work normally within Access but now only works read-only via my 
ASP pages.

Tim


  Return to Index