[AccessD] Fwd: Transpose out of memory error - 20,000 entries

[Jim Dettman]

 Couple things on that:

1. "Out of memory" can stem from running out of locks (MaxLocksPerFile
setting).

2. It might have also been process address space.

  One of the reasons that Microsoft is now recommending 64 bit is because it
allows for more process address space.   The "out of memory" trend is
growing with latter versions of Office because Office is getting bigger and
bigger. When running in 32 bit mode, it's limited to 2GB of process space
even on a 64 bit OS.   A 32 bit process can access more memory if its "large
address aware", which increases the limit to 3GB.   Outlook and Excel are
LAA (not sure about Word), but Access is not, so 32 bit Access is still
stuck at 2GB.

 It's a current request on Access User Voice
(https://access.uservoice.com/forums/319956-access-desktop-application/sugge
stions/32586994-make-32-bit-access-large-address-aware-laa) to make 32 bit
Access LAA.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Tuesday, February 26, 2019 1:33 AM
To: Microsoft Access Database Discussion List; Access Developers discussion
and problem solving
Subject: [AccessD] Fwd: Transpose out of memory error - 20,000 entries

Automating Excel from MS Access in Office 15 with 8GB RAM.

I was using copyfromrecordset from an Access DAO recordset to an excel
range. I was doing some cleanup in the automated excel instance. I often
assign a range to a variant, loop elements, change strings, then paste back
to the range using transpose. But Access ran out of memory. Many of the
20,000 elements had thousands of characters. After scratching my head
awhile I realized maybe I should close the recordset and set the variable
to nothing after using CopyFromRecordset. That did the trick.

Just thought I would pass this along.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com