View Single Post
  #5  
Old July 20th, 2006, 09:25 PM posted to microsoft.public.access
Bill
external usenet poster
 
Posts: 25
Default Where is Query in Access XP???

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" wrote in message
...
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.



--

Terry Kreft


"Bill" wrote in message
...
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" wrote in message
...
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.

--

Terry Kreft


"Bill" wrote in message
...
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?