How do I find Lock and Validation Rule Violations?

  • Thread starter Bob in Danville
  • Start date
B

Bob in Danville

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.
 
K

Klatuu

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!
 
B

Bob in Danville

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