Insert Query Not Working

I am having a problem getting an insert query to work. Here is the code:

sql="Insert into tblInCart(user, item_number, qty, price, description, taxcode) Values('" & user & "', '" & item & "', " & qty & ", " & prc & ", '" & desc & "', '" & tax & "')"
set rs2 = db2.execute(sql)

This was the error statement:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
It points to the "set rs2=db2.execute(sql)" line

The sql statement looks like this: Insert into tblInCart(user, item_number, qty, price, description, taxcode) Values('EXMPLE', '100BLUERASP', 1, 3.99, 'MIX COCKTAIL BLUE RASP', 'N')

The user, item_number, description, and taxcode fields are text, the qty field is integer, and the price field is currency. The rs2 recordset was previously used for a select query, which works fine, but it is closed before this happens.