[AccessD] Access 32-64 bit question

Sun Nov 14 16:30:17 CST 2021

Thanks for clearing up the mud, Jim. Meanwhile, I'm going to spin up a VM
and install the old 320bit Access and then try to resolve the 32->64
problems that I have with ADH. It would be soo nice if someone who has
already done this would just send me their converted bas files. It's after
all my birthday tomorrow 😉

On Sun, Nov 14, 2021 at 3:25 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> Arthur
>
> << So what I have gathered from this thread is that, other than the
> ability to
> have humongous Excel sheets or work with really large data sets, there is
> nothing to be gained by switching to 64-bit>>
>
>    There is one thing, and that is getting more process address space.
>
>    A 32 bit app is limited to 2GB of memory (with 32 bit, you can address
> 4GB, but 2GB is reserved for the OS).   The problem is, as more and more
> features are packed into Office apps, the bigger their memory footprint has
> become.     To get around that, all Office programs except Access have been
> made "Large Address Aware", meaning they can encroach on the OS's address
> space and go up to 3GB.
>
>    Since Access is not Large Address aware however, complex apps with
> newer versions can run out of process address space, at which point you'll
> get a "system resources exceeded".
>
>    So there is an advantage to going with 64 bit.
>
>    Sorry to hear about the eyesight, and yes, health care is out of
> control here in the US.
>
>    As for the e-mail, what client are you using?
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Arthur Fuller
> Sent: Sunday, November 14, 2021 1:35 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Cc: Jim Dettman <jimdettman at verizon.net>
> Subject: Re: [AccessD] Access 32-64 bit question
>
> So what I have gathered from this thread is that, other than the ability to
> have humongous Excel sheets or work with really large data sets, there is
> nothing to be gained by switching to 64-bit. If this surmise is incorrect,
> please advise. That's after all why this site bears the name it has. 😉
>
> As a loyal Canadian, I like most up here  love to point the finger at
> the US health care system -- until our own system bites us. This has
> happened to m: I'm 74 years old tomorrow and recently visited an
> ophthalmologist due to my impaired vision. That's when I learned that I
> need that I need cataract surgery on both eyes, and after that surgery for
> macular degeneration. Here comes the strange part. Virtually everybody in
> my age bracket either needs or soon will need thiese operations -- and yet
> while the ops are covered by the health care system, the tests are not, and
> that means I have to find $600 to get it all done. Tough for a retired
> person on a fixed income. Compound this with the desperate search for
> employees by all sorts of companies, and they are begging us seniors to
> remain in the work force, because there is an ever-decreasing number of
> young people to fill the job space.
>
> Lastly, can someone pease tell me how to get rid of this annoying toolbar
> that pops up whenever I try to send or receive a message in Gmail? It's got
> icons for UnDo, ReDo, Font, TrueType and so on, and I despise it. Once in a
> very long while I would like it to appear, but never automatically. It's
> annoying enough to make me think about switching email clients.
>
> On Sat, Nov 13, 2021 at 6:27 PM Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > Declare and use refular functions that use the APIs and declare variables
> > to send to the APIs and code like strPtr, AddressOf and a ton of areas IN
> > the main code is what I am talking about. This is where I spent the vast
> > majority of my time.
> >
> > On Sat, Nov 13, 2021 at 6:22 PM Bill Benson <bensonforums at gmail.com>
> > wrote:
> >
> > > Possibly but not necessarily how to declare and use. Hopefully no one
> > > requires me to show code to probem my point- can’t, company would
> forbid.
> > >
> > > On Sat, Nov 13, 2021 at 12:58 PM Jim Dettman via AccessD <
> > > accessd at databaseadvisors.com> wrote:
> > >
> > >> << I don't know how to distinguish which arguments need to be
> > converted>>
> > >>
> > >>   You look them up in the Win32API_PtrSafe.txt that was referenced
> > >> earlier.
> > >>
> > >>    Give us five or six of the declares you are using, and we'll show
> you
> > >> how
> > >> they need to appear.
> > >>
> > >> Jim.
> > >>
> > >> -----Original Message-----
> > >> From: AccessD On Behalf Of Arthur Fuller
> > >> Sent: Saturday, November 13, 2021 11:23 AM
> > >> To: Access Developers discussion and problem solving
> > >> <accessd at databaseadvisors.com>
> > >> Subject: Re: [AccessD] Access 32-64 bit question
> > >>
> > >> Martin.
> > >> Thanks for the link.  I have read it through and still have one
> problem.
> > >>
> > >> "To reiterate, you must modify the Declare statement to include the
> > >> PtrSafe qualifier,
> > >> and you must update any variables within the statement that need to
> hold
> > >> 64-bit quantities so that the variables use 64-bit data types.".
> > >>
> > >> I don't know how to distinguish which arguments need to be converted
> > >>
> > >>
> > >> On Sat, Nov 13, 2021 at 1:49 AM Martin <martinreid at gmail.com> wrote:
> > >>
> > >> > Arthur
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> >
> https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-b
> > >> it-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261
> > >> <
> >
> https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261
> > >
> > >> >
> > >> >
> > >> >
> > >> > Martin
> > >> >
> > >> > On Fri, 12 Nov 2021, 22:04 Arthur Fuller, <fuller.artful at gmail.com>
> > >> wrote:
> > >> >
> > >> > > I was praying for a better solution, but oh Well. So I uninstall
> > >> Office
> > >> > 365
> > >> > > and then reinstall Office 2007 and then reinstall Office 365,
> which,
> > >> > seeing
> > >> > > the previous installation, will install the 32-bit version.. There
> > >> goes
> > >> > > another entire days's work. Such is life.
> > >> > >
> > >> > > On Fri, Nov 12, 2021 at 1:12 PM Jim
> > >> > >
> > >> > --
> > >> > AccessD mailing list
> > >> > AccessD at databaseadvisors.com
> > >> > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > Website: http://www.databaseadvisors.com
> > >> >
> > >>
> > >>
> > >> --
> > >> Arthur
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> https://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> https://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
Arthur