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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12724-issuing-queries-to-97-database.html
--
Brendan Reynolds
Access MVP
"Jeremy"
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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12724
>Anything? Or am I limited to issuing one query at a time by clicking the !
>button.
>
> Thanks!
>