Unanswered: Problem inserting a record into An Access Database via ASPX
Having fits trying to insert a record. I've made a sample (see below), I can connect and query the table, but adding a record is giving me fits. first I got
"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype." So I tried every combination of cursortype and locktype but keep getting "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." I must be doing something wrong. It's an Access 2007 database on a web server. I eliminated some of the connection string for security in the open below, but it does connect.
<%@ LANGUAGE = "VB" aspcompat = "true" %>
Dim conn as object
Dim rs as object
Dim strSQL as String
strSQL = "Select WorkID from Cart where ProductId=5005"
rs.ActiveConnection = conn
rs.CursorType = adOpenStatic
rs.LockType = adLockPessimistic
rs.CursorLocation = adUseServer