Update wont work!

[adamsoderqvist]

Hi,

I have a sort of admin area for a forum. The admin is supposed to be able to update former messages in the DB (Access, BTW). It works allright, BUT for some reason some posts wont (while some works perfectly! This is the err-msg I get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

Now, the row is there but still the message!

Does anyone know?

//A

 

[sweevo]

What code are you using to update?

 

[adamsoderqvist]

Here's the code!

---

'Declare recordset object...
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset&quot

Dim strSQL
strSQL = "SELECT * FROM tblForum WHERE ForumID=" & Request.QueryString("PostID&quot

'Open the database and get the requested info!
objRS.Open strSQL, objConn, , adLockOptimistic

'Declare var's for message info...
strMessage = Request("NewMsg&quot

'..and update the database!
objRS("Message&quot = strMessage
objRS.Update

---

... and as I said: it's working allright with the other DB posts!