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