Access memory leak?

  • Thread starter Thread starter Today
  • Start date Start date
T

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.
 
Also, would it help my
memory resources to programatically attach and unattach a
table?
Click to expand...

No, can't think of any reason why that would help
I think I am having Access memory leaks and need some
Click to expand...

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)
 
Back
Top