[AccessD] Fwd: Re: Ac2013 running out of resources

Ryan Wehler wrwehler at gmail.com
Thu Jan 26 09:41:28 CST 2017


There's nothing really special about it. Forms with subforms and recordsets performing calculations and such

There's just a lot there. The app is used by everyone in our company in some manner. 

We never experienced these problems with Access 2003 or 97. Lot less memory usage from access itself. 

Sent from my iPhone

> On Jan 26, 2017, at 8:27 AM, Jim Dettman <jimdettman at verizon.net> wrote:
> 
> Couple comments:
> 
> 1. I'm curious what this app is like because it's rare for something to hit
> a memory resource limit like you have.
> 
> 2. I did recently however have a question on EE with more or less the same
> problem (resources, but it wasn't memory).   This was a heavy duty
> calendaring type app where one form in particular would always kick them
> over the limit (hundreds of controls and quite complex) if it was used in
> conjunction with a couple other forms.   So similar problem to yours.
> 
> What I suggested to them and what might work for you is splitting the front
> end up into multiple DB's running under two or more instances of Access.  In
> their case it was easy to split off the one form.  They allowed the user to
> start either part first (they split it into two), and would seamlessly fire
> up the other part when needed.   The tricky part was that they wanted to
> execute code in each DB from the other.
> 
> That was easy for the first executed part because it could grab a reference
> to the second, but the second had no way to get a reference back to the
> first easily.   Turns out it is possible with some windows API's and I did
> up an article on it:
> 
> https://www.experts-exchange.com/articles/28861/Obtaining-an-object-variable
> -for-a-running-instance-of-Microsoft-Access.html
> 
> Something to consider and it might resolve your dilemma.
> 
> Jim.
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Ryan W
> Sent: Wednesday, January 25, 2017 03:37 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Fwd: Re: Ac2013 running out of resources
> 
> AFAIK the /3GB switch was for the 32 bit version of Windows only for
> whatever reason.
> 
> The problem becomes using a 32 bit app on a 64 bit OS.  You're limited to
> 2GB of Virtual Memory (Page File).  The solutions are: slim your app down
> where you can or move to 64-bit Access.  The latter isn't recommended by
> seemingly anyone.  I had considered it but then I'd have to compile both 64
> bit accde and 32 bit accde since I do have some machines running 32 bit
> OS's still.
> 
> 
> 
> On Wed, Jan 25, 2017 at 2:27 PM, James Button <jamesbutton at blueyonder.co.uk>
> wrote:
> 
>> As a slight aside from the detailed and discussed problem
>> 
>> I believe there are options specifiable at windows startup to set windows
>> to
>> allow 32 bit applications to use 3Gb of memory rather than just 2GB,,
>> Additionally, for 32 bit OS the amount of real memory available includes
>> the
>> memory allocated to the video system
>> So having a video board with 1GB of onboard memory may well reduce the
>> memory
>> allocation available to many of the applications by that 1GB
>> Or even more memory than is on the video board if the board adds main
>> memory to
>> the allocation it acquires (reserves) from the OS's managed space.
>> 
>> JimB
>> 
>> 
>> 
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Ryan W
>> Sent: Wednesday, January 25, 2017 6:17 PM
>> To: Access Developers discussion and problem solving
>> <accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Fwd: Re: Ac2013 running out of resources
>> 
>> For the record I put Access 2016 Runtime on a VM and got "about" the same
>> experience. Using the VMMap.exe tool it seemed I was able to utilize about
>> 1.6GB of virtual memory for MSAccess before I ran into resource errors.
>> With 2013 it seems to happen around 1.45-1.5GB.
>> 
>>> On Tue, Jan 24, 2017 at 6:11 PM, John Colby <jwcolby at gmail.com> wrote:
>>> 
>>> And did they fix it in 2016 or whatever the current version is?  Or is
>>> this just another "develop in vba at your own risk" message from MSFT?
>>> 
>>>> On 1/23/2017 8:46 PM, Bill Benson wrote:
>>>> 
>>>> Ryan this is FYI
>>>> 
>>>>> From my non-flammable Note 3,
>>>> Bill Benson
>>>> ---------- Forwarded message ----------
>>>> From: "Mark Simms" <marksimms at verizon.net>
>>>> Date: Jun 8, 2015 9:43 PM
>>>> Subject: Re: [AccessD] Ac2013 running out of resources
>>>> To: "Access Developers discussion and problem solving" <
>>>> accessd at databaseadvisors.com>
>>>> Cc:
>>>> 
>>>> Thanks Jurgen - this totally confirms my suspicions: BUG
>>>> 
>>>> How much memory can AC-2013 consume ? Try 65 GIGs.
>>>> Yep...I've seen it in Task Manager. Unbelievable.
>>>> 
>>>> Another QA debacle by MSFT.
>>>> Attempt development with AC2013 AT YOUR OWN RISK.
>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http:// <http://www.databaseadvisors.com>
>>>> www.databaseadvisors.com
>>>> 
>>> 
>>> --
>>> John W. Colby
>>> 
>>> 
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list