Has Access has stopped working with an Error Message about 64-bit
You open your Access database that has been working for years and it now displays.!
How big is the problem
To find out, download and run our free scanner.
Included in the download is our ApiViewer, which provides 64-bit compatible versions of API functions to assist the manual15:32 26/04/2024 updating process.
As an alternative to manual updating we can supply our Access32to64Updater that automates the process.
For Updater details please Contact usDownload the latest version of our FREE AccessAPIScanner and Viewer
Download our original FREE AccessAPIScanner
Please note you will not be charged for the Scanner and Viewer.
What's wrong?
In the VB Editor lines that are not compatible with 64 Bit Access show red.
Error Lines
The Solution
Update all "Declare" statements to include PtrSafe and adjust their parameters from Long to LongPtr, where required. (LongPtr automatically becomes a Long in 32 Bit Office and LongLong in 64 Bit.) Adjust the code where API functions are called so that variables in the calls match the new data types in the Declare statements.
Updated lines with highlighted changes.
How big is the problem?
To determine the size of the problem run our Free AccessAPIScanner. It will tell you how many Declare statements there are and if there any that do not currently have known PtrSafe versions.
AccessAPIScanner2 (Beta) available 24/04/29
Scanner
If there any Declares without details the "Unknown" functions can be sent to ThemeMyDatabase for checking and possible inclusion in future updates.
Small number of Procedures to update.
Use our win32APIViewer which is supplied with the Scanner. For each Declare statement highlight and copy the Alias name and paste it into the Declares form of the viewer. (If there is no "Alias" use the Function/Sub name) After pressing enter the correct Declare statement will appear. It will have been automatically added to the clipboard ready to be pasted into your VBA code. When all Declares have been updated compile your Database. Type mismatch errors will occur in the calling code where there is a difference between the parameter type in the old and updated Declare statments. Adjust the Dims in the calling functions to match the new parameter types.
Viewer options.
Searching for the first Function in our errors
The Name has been filled in as OpenClipboard
Updated Declare is displayed. Showing PtrSafe and LongPtr.
The updated Declare has been added to the clipboard ready to paste into your VBA code.
Larger number of Procedures to update.
Use our Access32to64Updater!
The Updater checks your VBA code for Declare statements and any User Defined Types used by those functions and updates the Declare statements and Types where needed. It then adjusts the Dim statements in the calling code and optionally creates tests forms for simply checking the functionality of the updates within those
Access32to64Updater
