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

Open query analyzer results in acess

Hi,
   How to open query analyzer results in MS Access?

Thanks.
0
arunbhatt
Asked:
arunbhatt
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can't do it directly.
Instead encapsulate your query as a view.
Link / Open that view from SQL Server in Access so that you can view the results of the query in Access.
0
 
Patrick MatthewsCommented:
In addition, if you link the SQL Server tables in Access, then you can run the query in Access (although, if you do, you should do it as a passthrough, so it executes on the SQL Server rather than in Access).Going with the view, as rrjegan17 suggests, is the safer course.
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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