[AccessD] 64-but ONLY front end ?

[Ryan W]

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
>