Office Compatibility Issues

Run a 32-Bit Access ACCDB or ACCDE with 64-Bit Office

Huda QurayshiHuda Qurayshi Nov 20, 2026 869 views

Question details

Determine whether an Access database created with 32-bit Office can be opened or distributed to users of 64-bit Office.

Use a 32-Bit Access ACCDB or ACCDE with 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source database

In 64-bit Access, select File > Open and open the original ACCDB file.

2
Review VBA declarations

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.

3
Compile and test

In the VBA editor, select Debug > Compile, fix any reported errors, and then test the database's forms, reports, queries, and code in Access.

4
Check external components

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.

Update and test the ACCDB in 64-bit Access
Free Microsoft Office alternative

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.

Review and share data exported from Access as a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceInstall a free, lightweight Office alternative
QA img-9

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.