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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|