[AccessD] 64-but ONLY front end ?

Ryan W wrwehler at gmail.com
Wed Jan 18 07:57:25 CST 2017


Here's 2007 RUNTIME 32 bit on 64:

https://i.imgur.com/gltPxOh.png

Sadly I don't think 2007 will be a path worth chasing.  The initial bloat
is "about" the same as 2010/2013.

On Wed, Jan 18, 2017 at 7:46 AM, Ryan W <wrwehler at gmail.com> wrote:

>
>
> Here's 64 on 64.  You can see that "Free" is approximately 8TB.  There are
> no virtual memory limitations to hit with 64 on 64.
> https://i.imgur.com/AlzQrqz.png
>
>
>
> On Tue, Jan 17, 2017 at 9:20 PM, Ryan Wehler <wrwehler at gmail.com> wrote:
>
>> Then again you couldn't open my accdb made in 2013 with 2007 could you?
>> That may be a problem... that wasn't even the compiled version either.
>>
>> Sent from my iPad
>>
>> > On Jan 17, 2017, at 9:10 PM, John Colby <jwcolby at gmail.com> wrote:
>> >
>> > 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
>> >
>> > --
>> > 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