Query Error

[terawebwriter]

Could someone tell me what causes this error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/AddRecords/AddRecord-catano.asp, line 15

This is what the SQL statment looks like:

sqlString = "INSERT INTO SoftwareLicenses (SoftwareName, SerialNumber, LicenseCount, OrderNumber, RegNumber, DatePurchased)"

sqlString = sqlString & " VALUES ('" & SoftwareName & "','" & SerialNumber & "','" & LicenseCount & "','" & OrderNumber & "','" & RegNumber & "','" & DatePurchased & "')"

SET RS = objConn.Execute( sqlString )

 

[RobJDB]

Check the security settings on the database (are you using pws/iis?) - you need to have write permissions for the user (all users perhaps - depending on who's going to use your application). If this isn't clear, tell me more about your set-up.

Rob