Detecting a specific error using OLE DB Provider for Jet
Posted on 2001-06-05
I am trying to detect a specfic error when adding a new record using the .AddNew method.
The table in question is from SQL Server, linked to an Access '97 Database - hence the OLD DB Provider.
My problem is that I cannot seem to extract a specific error code - in this instance a 3022 (duplicate record).
I have tried the standard VB error object and the ADO errors collection, but all I get is -2147217887 (error detected, big help).
I assume there must be an API call I must use or something but cannot figure out what it is.
Any help would be appreciated.