If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fix memory leakage when you open Access forms > 300 times ,run ou.
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 |
#2
|
|||
|
|||
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" (david) "Ifoundit" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help! access, word, excel can't open or save documents | Bilal | General Discussions | 4 | April 21st, 2006 02:18 AM |
Can I close all open forms? | DBS | General Discussion | 3 | October 7th, 2004 04:35 PM |
There isn't enough memory? -- cannot open form | Darrell Wesley | Using Forms | 6 | August 18th, 2004 01:48 PM |
MailMerge cannot open Access QUERY data source | Chuck Hartman | Mailmerge | 3 | June 3rd, 2004 01:00 PM |