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"
wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12724-issuing-queries-to-97-database.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12724
>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!
>