Re: [MSAccessProfessionals] forms not opening in Windows Home

 

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 has spent a lot of time expanding and correcting it, which he actively continues to do. It’s a stand-alone tool you can launch and use to look stuff up. He named it win32apiviewer.accdb

 

VBA7 was introduced with Access 2010. VBA7 declares etc will work in 32 or 64-bit.

 

When I have a 32-bit database (VBA6) that needs to be made to also run in 64-bit, 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. 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. He’s also fixed the errors in the original source he got from Microsoft. … 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.

 

support@thememydatabase.co.uk

 

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