Hi
Anyone knows how I can run SQL queries in a batch..i.e. running strSQL one after another. For example, SELECT * FROM TABLE1 and then after that run SELECT * FROM TABLE2?
Thanks in advance.
mflower
Yes it will. Look at the QueryDef object in MS Access help. This is where you can programatically change properties of a query (even the entire SQL) before running it.
Give me more detail if you require more help.
lonniejohnson@prodev.com
ProDev, MS Access Applications B-) ,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.