Access 32 bit v 64 bit role out

Murray Brown
Murray Brown used Ask the Experts™

I have a detailed Access solution that my client wants rolled out to people with both 32 bit and 64 bit Office. I previously asked a similar question and was told that the solution would have to be developed on two machines. One with Office 64 bit and the other Office 32 bit. Is there no other way to achieve this?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
It depends on the solution...if its simple then no issues...but if you have ActiveXs and API calls you need to make the necessary changes
Also remember .accde compiled on x64 Access will work only on x64 Access and .accde compiled on x86 Access will work only on x86 Access
Most Valuable Expert 2015
Distinguished Expert 2018
Is there no other way to achieve this?

You can run, say, 64-bit Office on your main machine, then have a Virtual Machine running 32-bit for testing and minor corrections.
That's what I do.
The things to consider:
During development:
You must ensure your API calls (if you have any!) are both 32 and 64 bit compliant. You can find most api calls online, with the correct definition for both 32 and 64 bit. There are a few that require conditional compilation constants, but that is mostly relevant if you intend to deploy to Office versions 2007 and earlier. Since 2007 is out of support from MS, lets assume you don't want to do that.

For Deployment:
If you are deploying your solution as a ACCDB file, you are done. When the users Access opens the file, it will automatically recompile the code.
If you deploying as Accde (Compiled, locked, source code removed) you night to compile it once a 32bit office and once on a 64 bit office. You can use the same accdb file as source, but you need to compile it on the 2 different versions (32 and 64). You don't need a second PC, a virtual machine would do.
Murray Developer



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial