Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-21 : 11:06:21
|
Andrew writes "Greetings,
I'm writing a data entry application in Access 97, using SQL Server 2000 as a back end. I'm having difficulty trapping errors when they are generated by SQL Server.
For example if a Primary Key violation ocurrs in a SQL Server table, I get the message 'Violation of PRIMARY KEY constraint PK_xxxxxx. Cannot insert duplicate key in object xxxxxx. [#2627]... ' etc. Can Access handle this kind of error trapping, allowing me to convert it to something more elegant?
Thanks for your help
Andrew" |
|
|
|
|
|
Trapping Errors from SQL Server