How to disable Access default messages

%3CLINGO-SUB%20id%3D%22lingo-sub-1522529%22%20slang%3D%22es-ES%22%3EHow%20to%20disable%20Access%20default%20messages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522529%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20the%20following%20problem%2C%20I%20have%20a%20mobile%20application%20that%20saves%20the%20data%20in%20an%20Excel%20file%2C%20and%20I%20upload%20those%20data%20in%20Access%20about%203%20times%20a%20day%2C%20but%20since%20the%20Excel%20file%20contains%20the%20data%20from%2012%20tables%20that%20I%20want%20to%20upload%2C%20Access%20asks%20me%20confirm%20to%20the%20data%2012%20times%20(one%20for%20each%20table)%20the%20message%20it%20displays%20says%20like%20this%20something%20%3A%20%22...%2051%20records%20have%20been%20lost%20due%20to%20infringements.%22%20As%20I%20only%20want%20the%20new%20records%20to%20be%20uploaded%2C%20this%20message%20will%20always%20appear.%20Well%2C%20the%20question%20is%3A%20is%20there%20any%20way%20to%20disable%20this%20type%20of%20messages%3F%20thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1522529%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New 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