Update Error - read only error

[Peter]

I am having a problem Updating a record. I can read the access
database, but when I try to insert a record using


set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Guestbook", conn, 2, 3

' create new recordset.
rs.AddNew

the rs.Addnew failes with the following error

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

I have read/write allowed and the folder/db is not read only, I can
manually enter entries in through access.

I am using IIS 5 on xp, the local web has read/write as well

What am I doing wrong?
Thanks

[Aaron Bertrand - MVP]

> rs.Open "Guestbook", conn, 2, 3

>
> ' create new recordset.
> rs.AddNew

Use an INSERT statement, not a recordset object ([url]http://www.aspfaq.com/2191[/url])

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

[url]http://www.aspfaq.com/search.asp?q=80040E09[/url]

> I have read/write allowed

For what user?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]