lock violation when running Append query

[Guest]

I am running an Append query -- pretty straightforward Insert into Table1...
From Table2. I am getting a message that all records could not be appended
due to lock violations. What could this mean? No other program is using
either table.

 

[Michel Walsh]

Hi,


Is it possible that the program is updating a record through a recordset
(or through the form) at the moment you make the update query? If so, try to
save the record, or undo it, before running the update query. Alternatively,
if the form is using a pessimistic lock, the record may be lock when the
update is running.



Hoping it may help,
Vanderghast, Access MVP