This is some of the previous thread contents related to this topic:
ps, Peter’s free API Viewer tool lets you look up APIs by Declares, Constants, and Types. He got the original list from Microsoft and spent a lot of time expanding and correcting it, which he actively continues to do. The API Viewer is a stand-alone tool (Access ACCDB database) you can use to look stuff up. He named it win32apiviewer.accdb in the last download I got, which is enough for me! That has all the basics plus a lot more. If API calls aren't in there, they are probably obscure.
VBA7 was introduced with Access 2010. VBA7 declares etc will work in 32 or 64-bit.
When I have a VBA6 project (32-bit database) that needs to be made to also run in VBA7 (32 and 64-bit), if it will take a lot of hours, I ask for Peter’s help. He spent a few years writing his tool to convert to VBA7 (which many refer to as 32 to 64) and is still expanding it. So if you send him your database, he can convert it quick. When he gets a database with an API call he can’t convert, it will usually be because there is no VBA7 equivalent – and often those calls aren’t needed anyway. If that’s not the case, he gets excited to find out why. He’s also fixed the errors in the original source information that he got from Microsoft (which is all many others who haven’t done the testing that he has have). … and he’s a super nice guy. He’s in the UK and, in my opinion, the world expert on 32-64.
Kind regards,
crystal
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Friday, February 6, 2026 9:53 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home
Hi Dean,
Peter Cole has a tool to automatically make the conversions and if you have many of them or get confused, you should email him and ask for his help.
Peter also has a page with a couple free tools that you can download:
https://www.thememydatabase.co.uk/access32to64.html
When you click the blue Download button, you’ll be taken to a Gumroad page to add item to shopping cart. It’s free so don’t worry about getting it that way.
I have his API Viewer pinned to my taskbar
Kind regards,
crystal
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom via groups.io
Sent: Friday, February 6, 2026 12:07 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home
Hi Dean,
Can you describe what you mean by "won't work"? Do you have 32-bit API calls? If so, these need a slight modification in the code. Collin has some great information at 32 to 64-bit Conversion.
Duane Hookom
From: Dean Waring via groups.io <deanjw2006=msn.com@groups.io>
Sent: Thursday, February 5, 2026 9:03 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home
I have a multi-user Access database that our group has been using for over 10 years. The company is upgrading individual computers to the 64 bit version of Access. My 32 bit Access program won't work in this environment. Does anyone know if there is a way to make a 32 bit program run in a 64 bit environment, or if there is a way to convert the DB to 64 bit?
Dean J. Waring
~~~~
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Friday, February 6, 2026 12:56 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)
changed subject FROM forms not opening in Windows Home TO 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)
~~~
Dean, when you post a new message that isn't related to the thread, change the Subject. Best is to make a new message to the group.
~~~
