Detecting sql error problems

R

Roy Goldhammer

Hello there

If i run ado and do insert/update

and an error of key occur i got an error: -2147217887

this error occur if any validation of key: unique constraint key, constraint
key or reference key.

Is there a way to know on access which of the problem occur?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Level resource allocation error 1
Resync fails to use primary key 0
"Compile error in table level validation expression " after format 0
Insert records into a table with a primary key 0
Copy Records within a Table with SQL 7
Cumulative formula for word table 0
BCM 2007: Error ActivityType Foreign Key constraint 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top