dbfailonerror prob

  • Thread starter Thread starter Sebastian Balschuweit via AccessMonster.com
  • Start date Start date
S

Sebastian Balschuweit via AccessMonster.com

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
 
with leave the dbfailonerror option , i mean without the dbfail on error
option
 
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 ..."
 
Back
Top