OUT OF MEMORY ERROR WITH XP AND 2003 ACCESS

[Patrick Stubbin]

I am continually getting an out of memory error running access 2003 on xp, i
have 512mb of memory on the pc


ANy thoughts gratefully appreciated

 

[Tom Wickerath]

Hi Patrick,

Do you get these errors if you are using the sample Northwind database? Is
there anything else that you can tell us about your database that experiences
such errors? For example, are you opening recordsets in code (perhaps in a
loop), but failing to close them and set the recordset variable = Nothing at
the end? Do you have lots of images that are included in a report, and the
error occurs when previewing or printing the report?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I am continually getting an out of memory error running access 2003 on xp, i
have 512mb of memory on the pc


ANy thoughts gratefully appreciated

 

[Patrick Stubbin]

The actual error is "insufficient memory to undertake task, error 2004",

it occurs randomly whilst i have a form (tab type) opened, there are over 30
tabs in the form

 

[Patrick Stubbin]

it doesnt tend to happend when viewing reports but sometimes if trying to
open a report from the tab form it will, but then also does if i navigate to
any tab page.


but as i said, is rather random in its nature

 

[Tom Wickerath]

Okay, with over 30 tabs, this makes me wonder if you are loading a bunch of
bound subforms on several of these tabs. If so, you might want to look into
the idea of Tab On Demand, where you use late bound subforms that are only
populated if and when a user clicks on the tab.

The Tab On Demand technique is described in a paragraph on this page:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________