Ignore keyviolation in appendquery

[John J.]

In code I run several appendqueries starting with docmd.setwarnings = false.
Due to keyviolation Access does give me a warning/error. But I do want the
non key-violating values to be added, without the error message.

Is this possible?
Thank you.
John

 

[John W. Vinson]

In code I run several appendqueries starting with docmd.setwarnings = false.
Due to keyviolation Access does give me a warning/error. But I do want the
non key-violating values to be added, without the error message.

Is this possible?

Only by removing the constraint in the table.

Why would you want to have a rule prohibiting invalid data, and then turn
around and add invalid data? Either remove the rule, or fix the data; you
can't have it both ways!

 

[Ken Sheridan]

John:

Are you calling the Execute method with the dbFailOnError option? If you
instead call the OpenQuery method then rows which don't violate the key
should be inserted into the table.

Ken Sheridan
Stafford, England

 

[John J.]

Thanks Ken. That dit it!

John:

Are you calling the Execute method with the dbFailOnError option? If you
instead call the OpenQuery method then rows which don't violate the key
should be inserted into the table.

Ken Sheridan
Stafford, England

 

[John J.]

The *non* key-violating data is not invalid.

Only by removing the constraint in the table.

Why would you want to have a rule prohibiting invalid data, and then turn
around and add invalid data? Either remove the rule, or fix the data; you
can't have it both ways!

 

[Paul Shapiro]

You could modify the source query to eliminate the invalid data. Then the
insert should work as expected.