error 3426 this action was cancelled by an associated object?

[Leeper77]

Does anyone know what this means and how do correct this? Is this major? I mean will ihave to redo all the coding ive done allready

[Gil Ben-Yosef]

Usualy, this error occur when you are in a middle of editing record and try to read it again or edit it again. Check if the editmode property <> 0 before you have got this error.

Gil

[pardede]

i quite agree with gil,
do you use begintrans/committrans/rollback?
if you do, this could be the source of the problem, look out for refresh methods of recordsets, as this implicitly does a rollback

[Lil Dave]

Hi,

This 3426 has been the bain of three projects of mine as well. I must have written my code oddly for all three to give me the error. Oddly enough though, I have at least 15 other forms that run fine using AddNew, Edit, Delete, Update methods of a data control (any of these lines ten to causes the error).

One of the regulars here, offered to have a look at my code and see if he could spot the problem, but he hasn't let me know if he found the problem yet. He suggested not using a data control so I have rewritten the code to perform the AddNew, Edit and Delete in SQL.

I have checked all the field names in the DB and search on the Net for answers, tried the EditMode test, checked for Nulls, and tested for bad field names and data types.

I would hope that he does find the error, just so I know what it was.

It appears that multiple circumstances cause the error and as yet there is no one definite cause to blame.

Good luck and get into that SQL.

Cheer Dave

[Leeper77]

sql? I am not familiar with sql can one of you help me with this? Thank you im not use to sql so if one could tutor me a little using it in vb that would be great thanks

[Leeper77]

Ok guys i have gotten past the application error now i am having one more error it is 3058 index or primary key cannot contain a null value..... I know logically what this means but there isnt a null value its adding the data from the labels to the new database... do any of you have any ideas?

[MartinLiss]

I did an "all open forums" search for "3426" and found a half a dozen posts. It seems to have something to do with null values. Maybe if you take a look at the responses you'll get some hints.

------------------
Marty
Can you buy an entire chess set in a pawn shop?