A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Where is Query in Access XP???



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2006, 07:41 AM posted to microsoft.public.access
Bill
external usenet poster
 
Posts: 25
Default Where is Query in Access XP???

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?



Ads
  #2  
Old July 20th, 2006, 08:16 AM posted to microsoft.public.access
Terry Kreft
external usenet poster
 
Posts: 213
Default Where is Query in Access XP???

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?





  #3  
Old July 20th, 2006, 04:55 PM posted to microsoft.public.access
Bill
external usenet poster
 
Posts: 25
Default Where is Query in Access XP???

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?







  #4  
Old July 20th, 2006, 05:34 PM posted to microsoft.public.access
Terry Kreft
external usenet poster
 
Posts: 213
Default Where is Query in Access XP???

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?









  #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?











  #6  
Old July 20th, 2006, 09:53 PM posted to microsoft.public.access
Terry Kreft
external usenet poster
 
Posts: 213
Default 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?













 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.