Run a 32-Bit Access ACCDB or ACCDE with 64-Bit Office
Question details
Determine whether an Access database created with 32-bit Office can be opened or distributed to users of 64-bit Office.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A database owner wants to update an ACCDB in 64-bit Access and distribute an ACCDE to users with different Office bitness.
- Observed behavior
- Compatibility depends on the database's VBA declarations and dependencies; compiled ACCDE files must match the Access bitness used to run them.
In Access, open File > Account > About Access and check whether the installed version is 32-bit or 64-bit. Identify any Windows API declarations, ActiveX controls, and other dependencies in the database before testing it.
Update and test the ACCDB in 64-bit Access
Use the source ACCDB to check and correct code and dependencies before moving to 64-bit Access.
An ACCDB created in 32-bit Access can generally be opened in 64-bit Access, but VBA code and external components may need changes. Adding PtrSafe alone does not guarantee that an API declaration is correct; pointer and handle parameters also need appropriate data types.
In 64-bit Access, select File > Open and open the original ACCDB file.
Press Alt+F11 to open the VBA editor. Review Declare statements for Windows APIs, add PtrSafe where required, and use LongPtr for pointer and handle values when appropriate. Use conditional compilation where different declarations are needed.
In the VBA editor, select Debug > Compile, fix any reported errors, and then test the database's forms, reports, queries, and code in Access.
In the VBA editor, select Tools > References to check for missing libraries. Verify that any ActiveX controls and other external components are available in a 64-bit version.

Compile separate ACCDE files for each Access bitness
Use this approach when distributing a compiled database to both 32-bit and 64-bit Access or Access Runtime users.
Work with exported Access data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for an easier transition. Export Access data to a spreadsheet when you need to review or share it; WPS does not run ACCDB or ACCDE databases or fix Access bitness issues.

Frequently Asked Questions
Can 64-bit Access open an ACCDB created in 32-bit Access?
Generally, yes. Open it with File > Open, then compile and test its VBA code. Windows API declarations and external components may need 64-bit-compatible changes.
Can one ACCDE run in both 32-bit and 64-bit Access Runtime?
No. Compile separate ACCDE files in 32-bit and 64-bit Access, then distribute the file matching each user's Access Runtime bitness.
Is adding PtrSafe enough to make every VBA declaration compatible?
No. In the VBA editor, review the full Declare statement and use appropriate types, such as LongPtr for pointers and handles. Check each API's expected parameter and return types.
Can I install 32-bit and 64-bit Office side by side?
Microsoft Office installations of different bitness generally cannot coexist on the same computer. Use separate computers or virtual machines to compile and test both versions.
How can I check my Access bitness?
In Access, select File > Account > About Access. The information window identifies the installed version as 32-bit or 64-bit.




