I am using the following code to issue an update command to a database record:

set objDBConn = Server.CreateObject("ADODB.Connection"
strConn = MM_connIdiumCustomerDB_STRING
objDBConn.Open strConn
strCommandText = "SELECT username, password, loggedIn, loggedIndate FROM customers WHERE username = '" + Replace(rsUser__varUser, "'", "''" + "' AND password = '" + Replace(rsUser__varPassword, "'", "''" + "'"
'objDBConn.Execute strCommandText, , adCmdText

rsUser.Update "loggedIn", loggedInCount
rsUser.Update "loggedInDate", loggedInDate

But I get this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/idium/login.asp, line 53


The code works on my laptop running IIS 5 but uploaded to a Win2000 server running IIS 5 does not work.

I have used the code on another site and it works fine. What could be the problem?