• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Seeing Access Passthrough queries in SQL Server

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
1 Solution
Ryan McCauleyCommented:
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.
PeterFrbAuthor Commented:
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now