INeedAccessHelp
MIS
While running an append query, I keep getting 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. 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.