Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit?

Newsgroups	comp.databases.ms-access
Date	2023-05-25 11:38 -0700
References	(2 earlier) <00a5aec3-1161-441e-bbd4-dc6c17052377@googlegroups.com> <72024554-4c98-42b3-a534-62b9995312ec@googlegroups.com> <88ed41a5-55f2-4d5c-9ca0-14a1fa49f858n@googlegroups.com> <b9045ae8-5441-45ae-9d31-bd7b2639d7a2n@googlegroups.com> <6fae00c3-90fc-4470-a416-9321d582b43cn@googlegroups.com>
Message-ID	<258cc3bf-f46d-41f3-8dd0-b07f3d0d54f8n@googlegroups.com> (permalink)
Subject	Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit?
From	Ron Paii <ron81pai@gmail.com>

Show all headers | View raw

On Thursday, May 25, 2023 at 8:09:26 AM UTC-5, James wrote:
> I just converted an Access app I built 10 years ago from 32 bit to 64. Mainly because our default installation base is 64 bit Office across the Enterprise, plus as Albert mentioned, time does march on and I did not want to hang on to older technology that is clearly being replaced. Plus, that app is conflicting with other 64-bit apps that we depend on. 10 years ago, 32 bit was definitely the standard in Office deployments; now, not so much. More and more software is being developed as 64-bit, so I spent some time converting my Access app from Access 2013 32-bit to Access 365 64-bit. It's more of an automated application instead of one being used interactively, so the transition was not that painful. Plus, we have other apps on the same machine that are 64-bit, and which use Office-based ODBC drivers, and you cannot have the same driver in both 32- and 64 bit on the same machine. I'm currently testing out my converted Access app (again, which runs in unattended automation all day) and so far the results have been good. Again, to Albert's point - if you have 32-bit dependencies, then you're kinda stuck unless you're somehow able to remove that dependency. 
> 
> James

Albert's 2017 post 
"There not an x64 bit version of the TreeView or the Calendar control – so once again before committing to upgrade access x32 to x64, then any ActiveX control used will have to be replaced with an x64 bit version. If such controls are not available (and they often are not), then moving to x64 would be a challenge."

Is out of date. Microsoft has a 64bit version of common controls (MSCOMCTL.OCX) for Windows 10. My forms using the TreeView control recompiled in 64 bit access with no changes. Using conditional compile I now maintain x32 and x64 bit versions of Access frontends only needing re-compile.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar

Thread

Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Garry Perkins <garryskipperkins@gmail.com> - 2023-05-24 07:51 -0700
  Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2023-05-25 11:46 +0100
    Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2023-05-26 12:33 +0100
      Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Ron Paii <ron81pai@gmail.com> - 2023-05-26 05:38 -0700
  Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Ron Paii <ron81pai@gmail.com> - 2023-05-25 05:05 -0700
    Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? James <lankfordjg@gmail.com> - 2023-05-25 06:09 -0700
      Re: Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? Ron Paii <ron81pai@gmail.com> - 2023-05-25 11:38 -0700

csiph-web