Force an Append Query in ADO

[OnTheFly]

In the DAO world you could write an Append Query that overlapped a table's primary key. It would add only the records that were new and unique and not the ones that were already in the table.

Does anyone know of a way to do this in ADO? My experience has been that the query just won't run. On execution of the SQL it gives an error and does not add any records, even though some of the records are unique and do not violate the primary key.


Hope this helps.

OnTheFly

 

[LonnieJohnson]

Can you trap the error number with a Resume Next statement?


Just shootin' in the dark.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!