Update query in ASP creates an error.

[qwert231]

I have what seems to be a permissions problem updating a database. I am now on XP with IIS5 and FPE2k2. It worked with same database on NT4Wk with IIS4 FPE2k2.
I've tried adjusting the permissions on the file, the folder and thru IIS.

>Here is the error.
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/includeSets.asp, line 62

>Here is the code:
Set objComm = Server.CreateObject("ADODB.Command&quot
objComm.ActiveConnection = strConnect
objComm.CommandText = "UPDATE tblNewOrderNum SET yOrders = '"&nNum&"'"
objComm.CommandType = adCmdText
objComm.Execute

 

[lobstah]

PRB: ASP Returns 'Operation Must Use an Updateable Query' Error (Q175168)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168