I am executing existing Access queries as stored procs from a .Net application. I create a connection and command object with the command text of "Execute QueryName". I then use the ExecuteNonQuery method and the query runs. That part is fine.
The problem I'm having is that Access will execute append queries that produce duplicate values by allowing just the unique records to append. When I execute the same query through my .Net app the entire append query fails if a single duplicate value would be produced.
I could rewrite all of the existing queries to only append unique records, however there are a lot of them. I'm hoping there is a parameter of some sort that will allow the existing queries to run as they would if executed via VBA code with the warnings suppressed.
Thanks in advance for any help.
The problem I'm having is that Access will execute append queries that produce duplicate values by allowing just the unique records to append. When I execute the same query through my .Net app the entire append query fails if a single duplicate value would be produced.
I could rewrite all of the existing queries to only append unique records, however there are a lot of them. I'm hoping there is a parameter of some sort that will allow the existing queries to run as they would if executed via VBA code with the warnings suppressed.
Thanks in advance for any help.