[AccessD] Access 32-64 bit question

Sun Nov 14 14:25:31 CST 2021

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