Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message during append query. Lock violation???

Status
Not open for further replies.
INeedAccessHelp

INeedAccessHelp

MIS
Jan 22, 2001
124
US
While running an append query, I sometimes get an error message that states 'Can't append all the records in the append query'. Goes on to say '...and it didn't add 1 record(s) due to lock violations. This is a huge problem because each time this message occurs, that record is deleted from the database. I am appending a record to a different table and then deleting that record from the current table. Any help would be greatly appreciated. Maybe error trapping to display a more user-friendly message AND keep the record in the database without changes??? Please help. Thanks in advance.
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
3K
dhookom
dhookom
serino
  • Question
Help with a Query. 1
Replies
13
Views
414
strongm
strongm
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
701
Andrzejek
Andrzejek
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
390
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top