How do I find Lock and Validation Rule Violations?

[Guest]

I have eight tables imported from Excel into Access. These are .cvs files.
I need to combine them into one table. When I attempt an Append Query I
receive a message that there is a Conversion Failure and I have Lock
Violations and Validation Rule Violations. I find nothing in my 1,000 page,
$50, Access book that helps me find and fix these violations. I would
appreciate any help.

 

[Guest]

You should consider creating an intermediate table that has no validation
rules to import your spreadsheet into or link to the spreadsheet rather than
import it. Then you will need to write some code to check for fields that
would violate the validation rules, present a report to the user so they can
correct the errors, then update the permanent table.

The locking problems are probably due to the table being in use by another
user. Check to see what your default locking is set to.

Two paragraphs and free!

 

[Guest]

Klatuu,
I appreciate your ideas and will try these alternatives. Thanks very much.
Bob