Seeing Access Passthrough queries in SQL Server

Posted on 2011-05-10
Last Modified: 2012-05-11
I have a database in Access that contains many passthrough queries.  When I create a linked server in SQL Server to this database, I see the local tables and queries that use the JET engine to execute, but I see neither linked tables nor passthrough queries in the SQL Server catalogue.  Is there a setting or stored procedure that will make these visible in the catalogue?
Thanks, ~Peter Ferber
Question by:PeterFrb
    LVL 28

    Accepted Solution

    I don't think you'll see these, as they aren't actually stored in the Access database. When you browse the linked Access Database, you'll see objects it contains, like tables and queries (views). The Linked Tables are just SQL Server tables located somewhere else, and the pass-through queries are just remote views set up on another SQL Server.

    In short, there's no way to view these since they're not local to the Access database.

    Author Closing Comment

    Sadly, I think you are correct.  I'm striking out on getting SQL Server to see a group of tables to which Access successfully links but SQL Server can't seem to.  I believe I am coming across the limits of the access the owners of this particular database see fit to give me.  Though frustrating, I think it important to know which alleys are blind ones, that I may cease to fruitlessly walk down them.  I believe I will have to find another means of gaining the access I want.
    Thanks, though.  Your contribution is important.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Microsoft sql server 17 30
    SQL Question 9 34
    Tracking a Database Lock - SQL 2014 10 31
    SQL Select Help with xml tags in a text field 9 23
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now