Log in

View Full Version : ODBC failure



Djblois
04-29-2010, 05:05 AM
Anybody Know what this message means and how do I prevent it from happening?

file:///C:/Users/Daniel/AppData/Local/Temp/moz-screenshot.png

orange
04-29-2010, 05:15 AM
Anybody Know what this message means and how do I prevent it from happening?

file:///C:/Users/Daniel/AppData/Local/Temp/moz-screenshot.png

The error message is from the Oracle ODBC. It is telling you that the Oracle table involved has a unique key constraint (NO DUPLICATES) has been violated (YOU HAVE a DUPLICATE).

To resolve the duplicate you have to do a check within your program that,
if the value you are trying to add already exists, then you must not try to add that record/value.

In Access you should look at the DCount function. Other approaches may also be used.