Where is Query in Access XP???

[Bill]

O.K., I know it's here somewhere. Add/Remove programs says it's already installed as
part of Office XP but I can't find it.

Where in Access XP is Microsoft Query to be found?

 

[Terry Kreft]

You don't tend to use Microsoft Query in Access.

Why not try and tell us what you are trying to do instead of how you are
trying to achieve it.

 

[Bill]

I want to run some test queries from my desktop, against an MS SQL database hosted on a
shared server. run the query against the database, see what is returned, to reach myself
SQL language.

 

[Terry Kreft]

You'd be better off getting the SQL Server client tools installed, then you
can use Query Analyser and be using TSQL directly. Make sure you install
SQL Server Books On Line (BOL as it's normally referred to) as this should
be just about all the help you will need.

Have a word with the SQL Admin as the tools are on the SQL Server install
disc.

To be honest you are better off getting a local install of SQL Server if
possible, rather than learning on a production server.

 

[Bill]

I must access the production server. Besides learning the language, there is specific
information I need on the configuration of the MS SQL database. It's backed up daily so
I'm not concerned about unintentional changes.

I still want the option of trying Microsoft Query first, because it's already installed
(albeit hidden?).

 

[Terry Kreft]

Fine if you want to learn the wrong dialect of SQL then do the following:-

Open Access
Open a database
Press Ctrl-G
In the immediate window type
?syscmd(acSysCmdAccessDir)
and hit enter

This will tell you where Access is installed if you open that folder you
should find MSQRY32.EXE

My recommendation to use a local version of SQL has more to it than just the
data on the server. If your dba is stupid enough to allow you to play on a
production server he may be stupid enough to not have secured it properly,
if he's got that wrong then you may be able to do anything on the server
itself not just within SQL server.