From QueryDef to plain SQL text

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a few queries in my MDB, some of them are using them as INNER JOINs.
(A SELECT in a SELECT but then using querydefs)

I would like to combine these SQL statements into one but they become highly
complex for me.
I rather would like to embed the SQL text into my application than keeping
them in the DB.

Is there an easy way or should i maintain the querydefs?



.

Relevant Pages

  • Re: From QueryDef to plain SQL text
    ... What SQL is generated by Access for each of the querydefs? ... Query2 contains a select which is based on another query. ... I would like to combine these SQL statements into one but they become ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: db FileLen question
    ... > The only thing I am creating temporarily is QueryDefs and Recordsets. ... Recordsets are purely memory structures and will not affect the mdb at all. ... Creating querydefs probably would cause bloating, ...
    (microsoft.public.access.modulesdaovba)
  • Code to export objects from one mdb to another
    ... I want to export all objects from one mdb to another. ... to export tables and queries looping through the querydefs and tabledefs ... that I cannot simply make a copy of the source mdb. ...
    (microsoft.public.access.modulesdaovba)