Access lock violation

  • Thread starter Thread starter jbuhse \(removethis\)
  • Start date Start date
J

jbuhse \(removethis\)

I get the following error message. I checked the knowledge
database and it only addresses validation rule violations,
not lock violation. The database is on a stand-alone pc,
so nobody else has access to it.

Microsoft Access can't append all the records in the
append query.

Microsoft Access set 0 field(s) to Null due to a type
conversion failure, and it didn't add 0 records to the
table due to key violations, (2) records due to lock
violations, and 0 records due to validation rule
violations.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click
Help.
 
It is possible that the table that the append query is trying to append to
is open and therefore can't execute the query.
 
In Tools->Options->Advanced:

Verfiy:
Default Open Mode: Exclusive
Default record locking: No locks
Open databases using record level locking: Clear checkbox.
 
Back
Top