where is query analyzer in Access Database?? please help me..
A:
Assuming you have a database open Open the query window it creates queries graphically there is a sql window option available once you have the query view open.
dartdog
2010-03-04 02:01:42
i am using nothwind be database.. in the view, there list data sheet view, pivot table, pivot chart,and design view.. but there is not query..
Abid
2010-03-04 02:06:53
The queries are in the design view.
JUST MY correct OPINION
2010-03-04 03:03:39
A:
You can:
- write the query in any source code that interacts with Access' DBO, ODBC, etc. interfaces;
- store queries in the Queries section of the design view;
- execute ad-hoc queries using third-party tools like Visual Access or other similar products (including many open-source ones).
JUST MY correct OPINION
2010-03-04 02:03:18
+3
A:
If you by query analyser you mean like SQL servers’ show execution plan, there is no direct relation however you can you the jet showplan switch to display what the actual execution plan is. Here is a link on its usage
http://articles.techrepublic.com.com/5100-10878_11-5064388.html
Kevin Ross
2010-03-04 08:12:06