Welcome to SPN

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

Sign Up Now!

Issuing Queries to '97 Database

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

  1. Jeremy

    Jeremy
    Expand Collapse
    Guest

    I need to update many tables and columns in an Access '97 database. I prefer
    to write my SQL statements manually (instead of using the graphical query
    builder or wizards). I understand how to use Access '97 to manually create a
    query ("SQL view") and then click the little ! button to get it to run. But
    what I'd like to do is be able to create many UPDATE statements in one
    editor window and execute any one of those at a time. This would be akin to
    using SQL Server Management Studio or Query Analyzer to issue sql batches or
    *portions* thereof to a SQL Server db. Is there any way to do the equivalent
    with an MS Access '97 database - or some way to get Query Analyzer or SSMS
    to connect to an Access '97 database? Any 3rd party tool? Anything? Or am I
    limited to issuing one query at a time by clicking the ! button.

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    World Uganda marks 100 years of Sikh presence by issuing 4 postage stamps Breaking News Feb 11, 2014
    Sikh News Punjab govt orders issuing of licences to wood based units (New Kerala) Breaking News Jan 10, 2008
    Importance of Hukamnama - Some Queries Sikh Sikhi Sikhism Jun 14, 2009
    Queries History of Sikhism Oct 26, 2006

  3. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    dim db as dao.database
    dim rs as dao.recordset
    dim qdf as dao.querydef

    set db = codedb
    set rs = db.openrecordset("tblSQL")
    set qdf = db.openquerydef("qdfSQL")

    while not rs.eof
    qdf.sql = rs!sql
    qdf.execute
    rs.movenext
    wend

    (david)

    "Jeremy" <A@B.COM> wrote in message
    news:O23JAvVoGHA.4240@TK2MSFTNGP05.phx.gbl...
    >I need to update many tables and columns in an Access '97 database. I
    >prefer to write my SQL statements manually (instead of using the graphical
    >query builder or wizards). I understand how to use Access '97 to manually
    >create a query ("SQL view") and then click the little ! button to get it to
    >run. But what I'd like to do is be able to create many UPDATE statements in
    >one editor window and execute any one of those at a time. This would be
    >akin to using SQL Server Management Studio or Query Analyzer to issue sql
    >batches or *portions* thereof to a SQL Server db. Is there any way to do
    >the equivalent with an MS Access '97 database - or some way to get Query
    >Analyzer or SSMS to connect to an Access '97 database? Any 3rd party tool?
    >Anything? Or am I limited to issuing one query at a time by clicking the !
    >button.
    >
    > Thanks!
    >
     
  4. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    There is nothing built-in, but it would not be particularly difficult to
    create something to do that in Access. You'd store your SQL statements in a
    table, use a form to view and select them, and code behind your command
    button would open a recordset on the selected records and execute the SQL
    statement stored in each selected record.

    --
    Brendan Reynolds
    Access MVP

    "Jeremy" <A@B.COM> wrote in message
    news:O23JAvVoGHA.4240@TK2MSFTNGP05.phx.gbl...
    >I need to update many tables and columns in an Access '97 database. I
    >prefer to write my SQL statements manually (instead of using the graphical
    >query builder or wizards). I understand how to use Access '97 to manually
    >create a query ("SQL view") and then click the little ! button to get it to
    >run. But what I'd like to do is be able to create many UPDATE statements in
    >one editor window and execute any one of those at a time. This would be
    >akin to using SQL Server Management Studio or Query Analyzer to issue sql
    >batches or *portions* thereof to a SQL Server db. Is there any way to do
    >the equivalent with an MS Access '97 database - or some way to get Query
    >Analyzer or SSMS to connect to an Access '97 database? Any 3rd party tool?
    >Anything? Or am I limited to issuing one query at a time by clicking the !
    >button.
    >
    > Thanks!
    >
     

Share This Page