Doug Murphy
dw-murphy at cox.net
Wed May 24 11:49:48 CDT 2006
This may be way off track but I have seen the same error message when saving snapshots. The problem comes from the path length of the location you are saving to. I found that if the file path string that I was using to save the file was over something like 136 characters I'd could reliably reproduce the error. Shorter path, no error. There should be an FYI message on this in the archives with the exact string length that I found as the culprit. This may not be your problem but it is worth looking at. Took me a few hours to track the problem down. Doug -----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