I am inserting several things into a database using an ADO Connection. There are several occasions where an unique record that I am attempting to insert is already present in the Database. This is as designed, and I wish for the insert to be attempted, then if there is a duplicate key an error will come back which I will ignore. The problem is that I have the following statement:

On Error Resume Next

I use this since I anticipate several items already being in the database that I wish to ignore. The problem is that when I get the error, the resume next never happens. The program halts as soon as I get the error. It also doesn't do it all the time, which is quite strange. Any ideas what is going on?