Create Access Query Using SQL from VB

[leonepaolo]

Hi,

From outside of Access, I'd like to create a query in Access programatically, just like you can create a table.

Background: I've created a number of queries which I modify at run-time. Instead of modifying them, I'd prefer to just create them at run-time. Frankly, I have to many queries, when I go into the mdb file, there's just too many queries to sort through when I'm trying to figure out something new. I would really like to add and drop queries at run-time as the program requires them.

Any comments and/or instructions would be greatly appreciated.

Thanks in advance,
Paolo

 

[PHV]

You may play with the QueryDefs collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886