By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,569 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

How identify offending field(s) when copy data to revised table?

P: n/a
To comp.databases.ms-access --

I recently made changes to some field validation rules in a table.
When I tried to "Copy" and "Paste Append" some records to the new
version of the table, from an older version, Access reported a
violation of a validation rule (though not identifying which field it
was) and -- refusing to put the records in the new version of the table
-- put them, instead, into a new table called "Paste Errors". I knew
that my old data violated my new validation rules, but was unable to
pinpoint which field(s) were causing the problem. Does anyone know how
I could find out exactly which field(s) were involved? I am using
Access 2003. Thanks much!

--Tom

May 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.