--------------------------------------------------------------------------------

Hi all,

Just a small question concerning the memory problem. Whenever we open an existing query inside a module:

DoCmd.OpenQuery ("Query Name")

Do we have to put another command line to close the query? Because I'm suspecting this will retain the results obtained from the query into the memory and expand the Access file. Since whenever we open a record set, we have to close it. I'm just wondering if we really need to close the query to prevent the file keep expanding since all of my access files are getting bigger everyday even though I haven't add anything to them, just re-run the modules. If we need to put a closing command, what is it?

Thanks a lot! Have a nice day folks!

Interesting... I never really thought of closing one like that because when I invoke a query via VBA, it's to create a temporary table of values. Otherwise, I use a DLookUp or something else to get values out of an actual query. I don't open it.

The syntax would be something like

DoCmd.Close acQuery, "Query Name", acSaveNo

Look up the CLOSE method in HELP.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division