MS Access cannot find object Query RRS feed

  • Question

  • I am using Access 2002 with data stored in SQL Server 2000.  I have a form with a table (say Table 1) and a button that is supposed to open a report that uses a parameterized query.  When I click on the button instead of printing the form, I get the following error message:

    MS Access cannot find the object Query

    The query was built in Access but shows up in Access as a query and in SQL Server as a function.  What can I do to make the query run?  I'm using a simple macro (OpenQuery command) to open the query with "Print Preview" and "Read only" options.

    • Moved by KJian_ Thursday, April 14, 2011 2:09 AM (From:SQL Server Data Access)
    Tuesday, April 12, 2011 4:35 PM