Anybody Know what this message means and how do I prevent it from happening?
[IMG]file:///C:/Users/Daniel/AppData/Local/Temp/moz-screenshot.png[/IMG]
Anybody Know what this message means and how do I prevent it from happening?
[IMG]file:///C:/Users/Daniel/AppData/Local/Temp/moz-screenshot.png[/IMG]
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).Originally Posted by Djblois
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.
Posting Permissions
Reply With Quote
