Fix memory leakage when you open Access forms > 300 times ,run ou.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Try this test open any simple form and close again ,eventually MSAccess will
bring up message not enough memory.
eg try Northwind database opening categories form..
Point at which it happens depends on complexity of form .This is a Big BANG
bug!
This occurs in ACCESS2003 ,ACCESS97 and probably all other versions.

Private Sub Categories_Click()
Dim n As Long
Do Until n = 4000

DoCmd.OpenForm "Categories", acNormal, , , acFormEdit, acWindowNormal

n = n + 1
Forms![Main Switchboard]![x] = n
Unload "Categories"
DoCmd.Close acForm, "Categories"

Loop
Exit Sub
End Sub
 
http://support.microsoft.com/kb/331989
"This problem is fixed in Office XP Service Pack 3"

I don't have any such problem in A97, but I don't
know what you are doing with
Unload "Categories"
Click to expand...

(david)

Ifoundit said:
Try this test open any simple form and close again ,eventually MSAccess will
bring up message not enough memory.
eg try Northwind database opening categories form..
Point at which it happens depends on complexity of form .This is a Big BANG
bug!
This occurs in ACCESS2003 ,ACCESS97 and probably all other versions.

Private Sub Categories_Click()
Dim n As Long
Do Until n = 4000

DoCmd.OpenForm "Categories", acNormal, , , acFormEdit, acWindowNormal

n = n + 1
Forms![Main Switchboard]![x] = n
Unload "Categories"
DoCmd.Close acForm, "Categories"

Loop
Exit Sub
End Sub
Click to expand...
 
Back
Top