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