I am running an SQL query in an Access 2000 database, using the DoCmd.RunSQL "INSERT INTO ...." command.

The SQL INSERT query is executed without any problems, but I would like not to get the message box that prompts the user to confirm the operation. ("You are about to append..." , "Microsoft Access can't append all the records...").

Is there a way to programmaticaly answer "Yes" to all of those questions?

Thanks,
Yaron.