Microsoft Access: why qdf.execute is not showing any warning?

By | May 31, 2006

I had an application in which I had a code like

Dim qdf as QueryDef
qdf = new QueryDef("Query")qdf.execute

The query was not running because of error but the application was not breaking at the time of error generation. To force the application to break/throw exception write the statement like

qdf.execute dbfailOnError

and by this way we can catch all errors.

Vishal Monpara is a full stack Solution Developer/Architect with 12 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user’s mind leveraging geographically dispersed team members.

Leave a Reply

Your email address will not be published. Required fields are marked *