Knowledge.ToString()

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 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.

Share

Comments

2 responses to “MS Access Pass-Through Query Error: Cannot Execute a Select Query”

  1. Sivababu Avatar
    Sivababu

    Hi Vishal,

    Greetings for the day!

    I need Small help from you.

    Whenever open Ms Access form I am getting below issues .

    Unpublished tables with lookups to published tables are incompatible with the Web.
    ACCWeb107007

    Not able to sync the Ms access form.

    Could you please me

    Reply
    1. Vishal Monpara Avatar
      Vishal Monpara

      Hello Sivababu,

      I don’t know much details about that error but you may want to go through the steps given on https://support.office.com/en-us/article/web-compatibility-check-schema-errors-5d5884b5-f490-48e4-916d-48bfaa0f226b for error ACCWeb107007

      Regards,
      Vishal Monpara

      Reply

Leave a Reply

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