INSERT INTO VALIDATION RULE VIOLATION How to identify specific records?

[us...@domain.invalid]

I have a routine to copy data to new versions of my app via insert into
sql statements. Unfortunately, due to evolution of my app, sometimes
the new version has more restrictive editing than an older version that
I am updating. Thus I get this message. It tells me only how many
records have errors, not which records or which fields.

Anyone have a nice solution to identifying the specific records involved?

Maybe even the specific field?

One way I have come up with so far is to do a duplicate insert into a
version of the table with no validation rules. Then do a query joining
the two, UNRESTRICTED ----> RESTRICTED and see what records are
missing.

Another would be to write a query with the equivalent selection as the
reverse of the validation criteria, such that any record that did not
meet the validation is selected. The down side here is the query would
have to be maintained.

I am hopeful there is a more elegant way?

Bob

[[MVP] S.Clark]

If you know that the Validation Rules exist, then you should add to your
migration process the necessary steps to scrub the data, prior to trying to
insert. Then you will know which records are bad, and hopefully find the
original for the bad data.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

<us...@domain.invalid> wrote in message
news:%23Nlrza3...@TK2MSFTNGP14.phx.gbl...