I have a script that pushes data into an access MDB using the addnew and update.
Table structure has changed and now is kicking because there is a duplicate.
In VBA within Access you can do this with a showarnings=false, but I am doing this within WBT.
Is there an equivalent line of code or should I be using something other than addnew?
With INSERT INTO.... in ADO using either Jet or the ACE Provider adding Jet OLEDB:Global Partial Bulk Ops=1 to the connect string will avoid duplicates on a key. Using Just Addnew() I'm afraid you are going to have to issue a select for the key or duplicate value, the addnew if the Recordset returns eof.