[AccessD] "Out of Memory" Error ... VBA Export to Excel

Hi Larry:

This problem should not be an issue on the current versions of Access. Which
version are you using?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Tuesday, May 23, 2006 7:35 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] "Out of Memory" Error ... VBA Export to Excel

Hi Folks:

I have a fairly complex application that dynamically creates an excel
workbook and worksheets from VBA (formatting is done via an Excel template),
then populates the sheets with data from recordsets, as well as formulas
using named ranges. Typically, when they're finished generating, they weigh
in at about 5-6 megabytes. 

While they generate OK on my development machine with 2gb RAM, the larger
exports have been failing at the last worksheet when I run it on a machine
with 1gb or less total RAM. Basically, the export stops and Access displays
a message box stating "Out of Memory". 

I've been closing the recordset objects, setting them to "nothing", but I'm
still getting the error.

Any ideas on how to troubleshoot this issue? Thanks in advance.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314.432.5886
fx. 314.432.3304


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com