MS Access Pass-through query Error: Cannot execute a select query

When I tried to run an UPDATE statement from pass-through query, it throwed error “Cannot execute a select query”. This is due to that fact the property ReturnsRecords is set to True which requires the pass through query to return results. If it does not return recordset, it will throw an error. You can correct… Read More »

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

I had an application in which I had a code like 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 and by this way we can catch all errors.