3426 - The Error Strikes Back

[Lil Dave]

Okay, this error is still giving me nightmares. Using VB5 and Access 97, when I do an ADDNEW or the UPDATE of an EDIT procedure, I get

3426 : Action was cancelled by an associated object

JHausmann suggested :

bad field names
data type mismatch
incorrect command sequencing
Full moon

as being possible culprits, I have ruled out all but the last one :-)

Rad_Brad suggested :

that it maybe because there is not data in the DB, which is not the case (when there is no data in the DB it accepts the first record and then gives me the error everytime I try to ADDNEW again.)

Some else suggested :

#1) A field name might be incorrect on one of your bound controls, or referencing a non-existent field
#2) The actual database file itself might be read only. Use windows explorer to find out

But I have checked both and all of these and there appears to be no problem

The Microsoft site gave me this link here, for the problem, but the solution and its application eludes me :
http://support.microsoft.com/support.../q189/8/51.asp

Does anyone have any other suggestions ?

Cheers Dave
aka Lil Dave

P.S. Thanks for reading to the bottom :-)

[Clunietp]

I guess I am that "Someone Else"....

Resolution: Don't use the data control.

Yes, you are welcome.

Or you can email me the project and I'll have a looksie....

[email protected]

Tom