I would like to edit a recordset, but whenever I try it,
update was not successfully and I got an error 3146.
Before you ask :
I am using ODBC.dll version 2.x
I'm using MS SQL 7 and already set the NOCOUNT value to OFF
My code :
Set myWorkspace = Workspaces(0)
strConnection = "ODBC;UID=" & strUser & ";PWD=" & strPWD & ";Initial
Set myDB = myWorkspace.OpenDatabase("dsn-entry", True, False,
strSQL = "Select * FROM table"
Set myRS = con.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges,
'works fine !
' myRs.LockEdit = False ?
If Not myRs.Updatable Then MsgBox "not updateable"
myRS("aktnr") = "01 00"
myRS.Update -> Error
Do you have any idea !
Thanks in advance