Connecting to an Access 97 database with the DAO data control and a dynaset
Apparently found the solution: in a Knowledgebase article (don't have the
number handy -- searched Microsoft site on Error 3426) it is pointed out
that the underlying recordset can become
inaccessible if there is an "implied update", which I was apparently doing.
Basically, group all your recordset moves at the beginning of a subroutine,
and save your updates for the very end, and this kind of error goes away.
Thanks for your reply.
>What's even more mysterious is.....
>What kind of database are you connecting to?
>What method of access are you using, ADO, DAO, ODBC DIRECT,.....
>What kind of recordset/cursor are you creating. Maybe it doesn't support
>>I'm getting a Run Time Error 3426
>>"This action was cancelled by an associated object."
>>when I try to use: "data1.recordset.moveprevious"
>>The help system has no information on this error message.
>>What does it mean and can anyone point to a solution?