problem with "addnew" function.

i just recentelly opened my own website and i added a message board, the problem is that every time i'm using the "addnew" function of a reccordset, i'm getting the following error message:

Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/eyalsite/post.asp, line 27

i added the file "post.asp"(as post.txt) so you could have a look at it too.
you could also see it for yourselfs at my site:
http://www33.brinkster.com/eyalsite
(just get in the message board and try to post a new message).
thanks in advance,

Funny-looking C/C++/C# code... :p

Quote:

---

Originally posted by SMurf
Funny-looking C/C++/C# code... :p

---

Pretty much!!!


Anyway....you might want to look at your error message as it almost certainly gives the answer

Quote:

---

Database or object is read-only

---

You cant add to a recordset for a readonly database...even if you are asking for a static cursor as you are

Also add Close calls to your Recordsets when you no longer need them

Use SQL statements, They are far faster.

Code:

---

conn.Execute("INSERT INTO Messages (ForumID, PostedBy,....) VALUES(" & Request ("ForumID") & ",'" & Request("PostedBy") & "'," & ...

conn.Execute("UPDATE Forums SET Posts = Posts + 1, LastPost= Now() WHERE ForumID = " & Request("ForumID") )

---

Note: Text values should be surrounded with single quotes.

Info on JET SQL:
http://www.devguru.com/Technologies/..._sql_list.html

Otherwise, I think that you may have to set the cursor location to adUseClient before opening a static recordset that you want to update. (Very not sure).
rs.cursorLocation = adUseClient