[AccessD] 64-but ONLY front end ?

Tue Jan 17 21:10:07 CST 2017

  hate to be the one to say it but IIWM I would be investigating Access 
2007 runtimes and just buy a copy of 2007 to dev in.  I have used 
runtimes extensively at one client.  No license required on the target 
machine.

You are developing around (or trying to) a HUGE issue with Access 2013.  
2007 definitely runs on Windows 10.  It also runs on the backwards 
Windows versions, perhaps even XP.

On 1/17/2017 10:00 PM, Ryan Wehler wrote:
> I thought about coming up with a form_open event that looked up how many forms were open and would bark if more than X were and let you select one to close. But I don't think that nag would go over well.....
>
> The easiest solution still seems to be to run the 64 bit version of Access. No JIT or memory management  involved.... to get us going down the next phase.
>
> But MS suggests you use the 32 bit version so I keep getting push back when I "ask around" about running 64 bit Access/Office.
>
> Sent from my iPad
>
>> On Jan 17, 2017, at 8:51 PM, John Colby <jwcolby at gmail.com> wrote:
>>
>> Actually you can force the issue.
>>
>>> On 1/17/2017 9:40 PM, Ryan Wehler wrote:
>>> I have one floating around. It's a marked improvement for sure but I'm not sure it will be enough.... I wish Access would release forms or tabs(form tabs not tab controls) that are in memory but not in focus to avoid stuff like this.
>>>
>>> If JIT controls isn't enough I'm not sure what else I can do other than try to tell people not to have too much open at once (like that would work)
>>>
>>>
>>> Sent from my iPad
>>>
>>>> On Jan 17, 2017, at 8:22 PM, John Colby <jwcolby at gmail.com> wrote:
>>>>
>>>> Have you managed to get a picture of the same 2013 x32 with JIT happening?
>>>>
>>>>> On 1/17/2017 3:35 PM, Ryan W wrote:
>>>>> A deeper look:
>>>>>
>>>>>
>>>>> Access 2013 32-bit on 64 bit OS:
>>>>> https://i.imgur.com/erUcFpo.png
>>>>>
>>>>> Access 2003 32-bit on 32 bit OS:
>>>>> https://i.imgur.com/1qCRQLm.png
>>>>>
>>>>>
>>>>> By the time I load my app up with JUST the switchboard open:
>>>>>
>>>>> Access 2013 32 bit:
>>>>> https://i.imgur.com/OkYxSsg.png
>>>>>
>>>>> Access 2003 32 bit:
>>>>> https://i.imgur.com/DeStcnt.png
>>>>>
>>>>>
>>>>> So I'm using 40% more memory just to run Access 2013!  Once I hit a "TOTAL"
>>>>> number of around 1.45GB I start getting out of resource errors.   When
>>>>> switching to 64 bit my memory wall becomes big enough (up to 8TB) that it's
>>>>> never ever a problem.
>>>>>
>>>>>
>>>>> Here we are with 5 of our most used and most commonly opened forms all
>>>>> opened up:
>>>>> https://i.imgur.com/RjPRpnd.png
>>>>>
>>>>> We are just barely skirting that limit here.  It would not take much (just
>>>>> a slightly larger data set on one of the forms) to stop the user in it's
>>>>> tracks.
>>>>>
>>>>> Those same forms open in Access 2003:
>>>>> https://i.imgur.com/ed296vH.png
>>>>>
>>>>>> On Tue, Jan 17, 2017 at 1:04 PM, Martin Reid <martinreid at gmail.com> wrote:
>>>>>>
>>>>>> He's been an amazing resource to
>>>>>> bounce ideas and questions off
>>>>>>
>>>>>> Has been for many years.
>>>>>>
>>>>>> Martin
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: "John Colby" <jwcolby at gmail.com>
>>>>>> Sent: ‎17/‎01/‎2017 18:01
>>>>>> To: "Access Developers discussion and problem solving" <
>>>>>> accessd at databaseadvisors.com>
>>>>>> Subject: Re: [AccessD] 64-but ONLY front end ?
>>>>>>
>>>>>> Assuming is mb?
>>>>>>
>>>>>>> On Jan 17, 2017 9:56 AM, "Ryan W" <wrwehler at gmail.com> wrote:
>>>>>>>
>>>>>>> For those following along:
>>>>>>>
>>>>>>>
>>>>>>> VMMap.exe (sysinternals) shows that Access 2003 sitting idle uses about
>>>>>> 75K
>>>>>>> of memory "total", Access 2013 (32 bit) is using 516K of memory "total"
>>>>>>> sitting idle. This is WITHOUT having my MDE/ACCDE loaded.
>>>>>>>
>>>>>>> Talk about bloat! It looks like a lot of this might be the 64 bit to 32
>>>>>> bit
>>>>>>> layer (SYSWOW)
>>>>>>>
>>>>>>> I'm still chasing down "JIT" forms (via Classes) with John Colby
>>>>>> providing
>>>>>>> assistance via email and telephone!  He's been an amazing resource to
>>>>>>> bounce ideas and questions off.
>>>>>>> --
>>>>>>> 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
>>>>>>
>>>> -- 
>>>> John W. Colby
>>>>
>>>> -- 
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>> -- 
>> John W. Colby
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com

-- 
John W. Colby