Solved

how can i get query analyzer for Ms Access 2007 ??

Posted on 2011-02-16
2
1,792 Views
Last Modified: 2012-05-11
i want to get the query analyzer in Ms Access 2007 , but how can i get it ?

please explain me via snapshot (e.g . go to options and all that) ...

so i can understand u in better way ...
0
Comment
Question by:Parth48
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 34905522
Do you mean the Query Builder in Access? That's located on the Create tab, under the Queries Group.

If you're referring to Query Analyzer as found in SQL Server Management Studio, then you can't connect SSMS to Access (at least as far as I know).
0
 

Author Comment

by:Parth48
ID: 34905845
just upload the snapshot for what u say ...
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Finding a job can be stressful - searches, resume tweaks, and networking events can be super boring. Luckily we're here to help you land your dream job!
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 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

10 Experts available now in Live!

Get 1:1 Help Now