eliminate message from append query to eliminate duplicate record.

[Guest]

How can I keep the error message "...cannot append all the records..." from
appearing to users when running a append query to eliminate duplicate
records. The query is running from a switchboard menu item and users are
afraid to accept continuing with the action.

 

[Allen Browne]

Execute the query without the dbFailOnError.

Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The article suggests using:
db.Execute strSql, dbFailOnError
but you want just:
db.Execute strSql