Access memory leak?

[Today]

I think I am having Access memory leaks and need some
advice on how to avoid them. Also, would it help my
memory resources to programatically attach and unattach a
table? Any help would be appreciated.

 

[david epsom dot com dot au]

Also, would it help my

memory resources to programatically attach and unattach a
table?

No, can't think of any reason why that would help

I think I am having Access memory leaks and need some

um...
Avoid errors/exceptions: don't use On Error Resume next.
Avoid temp queries/ dynamic SQL
don't pass objects to VBA library functions: always find values first, then
pass value to VBA library functions.
don't use global objects: always close and release local objects.

You need to identify the action that is causing the memory leak.

(david)