Question Is this an error OR a warning?

[Slider]

Hi

When writing to an Access file with one of the fields indexed (NO dupes allowed), I am getting the following message in the Immediate Window "A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll", when I enter a dupe.

I have put in a TRY, CATCH to catch the error and display a msgbox with the error.

Is this message in the IMMEDIATE WINDOW just a warning message (generated by access), or is there something wrong with my actual program? My program does not actually crash, it seems to be working great.

Can I ignore these messages?

Thank you.

 

[Hack]

Do you have Option Strict On?

That will tell you...

 

[Tom]

If you try to insert a duplicate key value into a table it will display an error and reject the insert. You can check the table to see if the record value exists prior to the insert.

 

[JohnH]

Hi

When writing to an Access file with one of the fields indexed (NO dupes allowed), I am getting the following message in the Immediate Window "A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll", when I enter a dupe.

I have put in a TRY, CATCH to catch the error and display a msgbox with the error.

Is this message in the IMMEDIATE WINDOW just a warning message (generated by access), or is there something wrong with my actual program? My program does not actually crash, it seems to be working great.

Can I ignore these messages?

Thank you.

Even if you catch the exception it still does happen, that is what the message means. David Kline : What is a First Chance Exception?