Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Where is Query in Access XP???

Discussion in 'Information Technology' started by Bill, Jul 28, 2006.

Tags:
  1. Bill

    Bill
    Expand Collapse
    Guest

    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. Loading...


  3. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    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" <bill541@yahoo.com> wrote in message
    news:erPcSe8qGHA.3820@TK2MSFTNGP05.phx.gbl...
    > 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. Bill

    Bill
    Expand Collapse
    Guest

    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" <terry.kreft@mps.co.uk> wrote in message
    news:uq0L9x8qGHA.1140@TK2MSFTNGP05.phx.gbl...
    > 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" <bill541@yahoo.com> wrote in message
    > news:erPcSe8qGHA.3820@TK2MSFTNGP05.phx.gbl...
    > > 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. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    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" <bill541@yahoo.com> wrote in message
    news:%233V$pTBrGHA.1796@TK2MSFTNGP03.phx.gbl...
    > 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" <terry.kreft@mps.co.uk> wrote in message
    > news:uq0L9x8qGHA.1140@TK2MSFTNGP05.phx.gbl...
    > > 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" <bill541@yahoo.com> wrote in message
    > > news:erPcSe8qGHA.3820@TK2MSFTNGP05.phx.gbl...
    > > > 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. Bill

    Bill
    Expand Collapse
    Guest

    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" <terry.kreft@mps.co.uk> wrote in message
    news:Os1otpBrGHA.4508@TK2MSFTNGP04.phx.gbl...
    > 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" <bill541@yahoo.com> wrote in message
    > news:%233V$pTBrGHA.1796@TK2MSFTNGP03.phx.gbl...
    > > 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" <terry.kreft@mps.co.uk> wrote in message
    > > news:uq0L9x8qGHA.1140@TK2MSFTNGP05.phx.gbl...
    > > > 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" <bill541@yahoo.com> wrote in message
    > > > news:erPcSe8qGHA.3820@TK2MSFTNGP05.phx.gbl...
    > > > > 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?
    > > > >
    > > > >
    > > > >
    > > >
    > > >

    > >
    > >

    >
    >
     
  7. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    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" <bill541@yahoo.com> wrote in message
    news:ea0$iqDrGHA.4996@TK2MSFTNGP04.phx.gbl...
    > 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" <terry.kreft@mps.co.uk> wrote in message
    > news:Os1otpBrGHA.4508@TK2MSFTNGP04.phx.gbl...
    > > 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" <bill541@yahoo.com> wrote in message
    > > news:%233V$pTBrGHA.1796@TK2MSFTNGP03.phx.gbl...
    > > > 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" <terry.kreft@mps.co.uk> wrote in message
    > > > news:uq0L9x8qGHA.1140@TK2MSFTNGP05.phx.gbl...
    > > > > 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" <bill541@yahoo.com> wrote in message
    > > > > news:erPcSe8qGHA.3820@TK2MSFTNGP05.phx.gbl...
    > > > > > 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?
    > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >

    > >
    > >

    >
    >
     

Share This Page