Problem with IIS - updating DB using ADO

I'm running IIS on Windows XP Pro, and I have a problem whenever I try to
add, delete or update records in a database using ADO. The DB is an MDB DB.
The error message I get is: "Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/blkbrd-sdc/default.asp, line 86"

I know that I don't have any problem with my script, I tried it on other
servers and it worked.

The permissions for the database and it's folder are set to READ and WRITE.

10X for looking :), hope u can solve my problem

Re: Problem with IIS - updating DB using ADO

Calltor wrote:
> I'm running IIS on Windows XP Pro, and I have a problem whenever I
> try to add, delete or update records in a database using ADO. The DB
> is an MDB DB. The error message I get is: "Microsoft JET Database
> Engine (0x80040E09) Cannot update. Database or object is read-only.
> /blkbrd-sdc/default.asp, line 86"
>
> I know that I don't have any problem with my script, I tried it on
> other servers and it worked.
>
> The permissions for the database and it's folder are set to READ and
> WRITE.
>
They need to be set to read/write for the IUSR and IWAM accounts on that
machine:
http://www.aspfaq.com/show.asp?id=2062
http://www.aspfaq.com/show.asp?id=2009

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.