Hi. I have a program that is running before, but not working now.
Here is the code that get the error:
Set rs = New Recordset
strSQL = "SELECT * FROM tbl1 WHERE id='myname'"
rs.Open strSQL, cnString, adOpenKeyset, adLockOptimistic, adCmdText
after I execute the rs.Open command, I always got an updatable recordset, but I got a read-only recordset now.
After the open command, I go to the immediate window check the recordset property
?rs.locktype is 1 instead of 3 as I expected with adLockOptimistic.
?rs.cursortype is 3 and not the adOpenKeyset as I specified.
Can anybody shed some light here.
btw, I use ADO2.5 before, now changed to ADO2.6, when I find the problem, I switched back to ADO2.5, still have the same problem.