How to disable Access default messages

Copper Contributor

I have the following problem, I have a mobile application that saves the data in an Excel file, and I upload those data in Access about 3 times a day, but since the Excel file contains the data from 12 tables that I want to upload, Access asks me to confirm the data 12 times (one for each table) the message it displays says something like this: "... 51 records have been lost due to key infringements." As I only want the new records to be uploaded, this message will always appear. Well, the question is: is there any way to disable this type of messages? thanks in advance.

0 Replies