connector / msAccess ODBCDirect workspace read only ?

[Joris Van den Dries]

When I try to run the following code, Access tells me the record is Read-only on the
Edit command. Why is this ? Please help...
I am using the latest stable connector and access 2003 (fully updated) on XP.
The same problem arises on my win98/access'97 system...


Dim wsODBC As DAO.Workspace
Dim rsODBC As DAO.Recordset
Dim cnODBC As Connection

Set wsODBC = DBEngine.CreateWorkspace("myODBCWS", "myname", "mypwd", dbUseODBC)
Set cnODBC = wsODBC.OpenConnection("myCn", dbDriverComplete, False, "ODBC;DATABASE=menagerie;DSN=Menagerie")
Set rsODBC = cnODBC.OpenRecordset("pet", dbOpenDynaset)

For i = 1 To 5
rsODBC.Edit ' why doesn't this work ???
rsODBC!sex = "K"
rsODBC.Update
rsODBC.MoveNext
Next i

rsODBC.Close
cnODBC.Close
wsODBC.Close

Set rsODBC = Nothing
Set cnODBC = Nothing
Set wsODBC = Nothing