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

By | June 19, 2008

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 this error by

  1. Open pass-through query into design mode. Click on Properties button (Alt+Enter) and set Return Records to No
  2. Using program you can set QueryDef object’s ReturnsRecords property to False.
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 *