Where is Query in Access XP???
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.
--
Terry Kreft
"Bill" wrote in message
...
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?
|