Check that IUSR has appropriate access rights (NT rights) to that mdb
file. It needs at least modify rights.

Teemu Keiski

-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Tim Morgan [mailto:aviatortim@h...]
L=E4hetetty: 4. kes=E4kuuta 2002 18:31
Vastaanottaja: Access ASP
Aihe: [access_asp] Access database mysteriously became read-only (help!)


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

Thanks Teemu.  I'm not familiar with that though.  How do I do that?

Tim

> Check that IUSR has appropriate access rights (NT rights) to that mdb
file. It needs at least modify rights.

Teemu Keiski

-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Tim Morgan [mailto:aviatortim@h...]
L=E4hetetty: 4. kes=E4kuuta 2002 18:31
Vastaanottaja: Access ASP
Aihe: [access_asp] Access database mysteriously became read-only (help!)


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

Disregard my second question; I found the solution.  I went to the file in 
Windows Explorer, right clicked the file, and selected "Properties" from 
the pop-up menu.  Under the "Security" tab, I had to select "Everyone" and 
give them write permissions.  This solved the problem.  

Of course, you already knew that but I thought I'd submit the details of 
the solution since this forum is archived for future reference of people 
having silimar problems.

Tim

> Check that IUSR has appropriate access rights (NT rights) to that mdb
file. It needs at least modify rights.

Teemu Keiski

-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Tim Morgan [mailto:aviatortim@h...]
L=E4hetetty: 4. kes=E4kuuta 2002 18:31
Vastaanottaja: Access ASP
Aihe: [access_asp] Access database mysteriously became read-only (help!)


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