View Single Post
  #6  
Old April 21st, 2010, 02:53 PM posted to microsoft.public.sqlserver.programming,microsoft.public.access.forms
Arvi Laanemets
external usenet poster
 
Posts: 397
Default Overriding constraint violation message

Hi

Thanks!

This link refers to almost same solution I found myself. But DBEngine.Errors
doesn't work for me. There exists only one item DBEngine.Errors(0) with
Number=3001 - "Invalid argument". And it doesn't depend on my actions which
caused the error (i.e. deleting linked data or entering some duplicate
value).

"Stefan Hoffmann" kirjutas sõnumis news:
...
hi Arvi,

On 21.04.2010 14:08, Arvi Laanemets wrote:
I think, the problem is that the error doesn't occur in Access, so
Access error indicators get nothing to show - the only exception are
parameters for forms OnError event DataErr and Response. (P.e. when
trying to delete a record linked to other tables, DataErr=3146 and
Response=1)

E.g.

http://archive.baarns.com/access/faq/ad_error.asp


mfG
-- stefan --