dbfailonerror prob

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sebastian Balschuweit - 31 Jan 2005 12:38 GMT

Hello again,
in my endless voyage through the wonderfull world of access Programming
(acc97) i found a new magic trick , where i need an explanation for.
My Prob: i have an Update SQL - String with a where condition who seek for
a String with like. This SQL-String i run with the dbfailonerror-option.
and if the string has a specific length access crashes. But... if i leave
the dbfailonerror option access works well. Is this a Know problem and if
yes ,why ?!

Greetings out of the snowy white wonderland fulda in germany

Reply to this Message

Sebastian Balschuweit - 31 Jan 2005 12:40 GMT

with leave the dbfailonerror option , i mean without the dbfail on error
option

Reply to this Message

Alex Dybenko - 31 Jan 2005 12:50 GMT

Yes, if you leave dbfailonerror out - then access will ignore all errors
normally - you have to have dbfailonerror and catch error if one is occur
using "on error go to ..."

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hello again,
> in my endless voyage through the wonderfull world of access Programming
[quoted text clipped - 7 lines]
>
> Greetings out of the snowy white wonderland fulda in germany

Reply to this Message