Error 3416 Action cancelled by associated object

Writing vb6 program with ACCESS using DAO data control. I get error 3426 "Action cancelled by associated object" at various times when I use the
actions such as
data1.recordset.addnew
data1.recordset.edit

1. Is there a list somewhere that tells you what causes vb6 and ACCESS runtime errors? Could not find anything in the MS knowledge base.

2. Do you know what causes the above error message and what to do about it?

I realize my thread is sketchy. If you need any more info please let me know. This is driving me crazy.

Thanks for your help.

 

Writing vb6 program with ACCESS using DAO data control. I get error 3426 "Action cancelled by associated object" at various times when I use the
actions such as
data1.recordset.addnew
data1.recordset.edit

 

http://support.microsoft.com/kb/q189851/

 

Thanks for your help....

 

Here is a more detailed explanation of my problem when using vb6 to add, edit, move, etc. database records and an DAO data control box.


The EOFaction property is set to 0-MoveFirst and the BOFaction property is set to 0-Movelast in the data control box..

My problem is putting in the very first record. At that point the recordset.EOF and recordset.BOF are set to true.

If I understand the situation, if either of these conditions are true the system is looking at a NULL record and not an empty record. Therefore, I will get Error 3416 if I attempt to any of the recordset methods that may involve a an explicit or implicit SAVE .

This problem only seems to happen only when I attempt to add the first record.

To be precise I would like to find out what code I would enter between the next two lines to be able to add a new record.

If recordset.EOF = true or recordset.BOF = true then
........
End if

I tried the suggestion posted in an earlier reply but it did not help.

Any suggestions greatly appreciated...............