Bypass message through VBA

[JMarcus]

Im getting a message "Database was unable to append all the data table" in a database and cant seem to troubleshoot the problem. Does anyone know the VBA to bypass it after the event is run. I think it is because someone was in the database as the linked table was being updated.

 

[Ranman256]

it could be many reasons. If the table has keys, it will not add duplicate records.
same with indexes set that way.
The command: docmd.setwarnings false
...should prevent the message.

 

[JMarcus]

worked like a charm. Thanks.

 

[sxschech]

Be sure to add a docmd.setwarnings true after the code you're intending to not show messages has completed, otherwise, you will not have warnings when you do other things including non code. For example, if you make a change to data or something else, but decide not to save it, you may not get the proper warning.