Access error using SQL Server

P

Penstar

I have an Access database which uses tables linked from an SQL Server. When
a user enters something that is a duplicate I get the following error:

OBDC --call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint "PK_Items_4D94879B'. Cannot insert duplicate key in object
'dbo.Items. (#2627)[Microsoft][ODBC SQL Server Driver][SQL Server]The
statement has been terminated. (#3621)

I also get similar error when trying to delete

OBDC --call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE Statement
Conflicted with the REFERENCE constraint "FK_IngredientDetails_Items". The
confilict occurred in databasse "ConKS", table "dbo.IngredientDetails",
column 'ItemID'. (#547)[Microsoft SQL Server Driver][SQL Server]The statement
has been terminated. (#3621)

How do I change the error message to simple wording so that the user can
understand?
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Keeping Access Running Between SQL Server Reboots 3
Create Stored Procedure in SQL server from Access VBA? 4
ODBC Call Failed - Numeric value out of range 2
what the heck does this mean? 8
Connecting to SqlServer 2005 Express 1
32 bit access application and 64 bit SQL 2008 2
Access Error using link table 0

Top