Will Access 32bit ACCDB run in 64 bit Office

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

Will an Access 32 bit ACCDB file run on a machine with 64 bit Office?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
Access applications without ActiveX and API calls should work just fine.
If you have BE other than Access you will need to check the ODBC driver to match the bitness.
As John says, if you are not using APIs and other third party controls you are fine. It will simply recompile.

If you are using API you need to make sure they are declared properly to support both 32 and 64bit, and also if you are deploying to earlier versions than 2010, there is some extra care to be taken regarding the LongPtr datatype and PtrSafe keyword.

The user needs to have the correct driver installed (if using ODBC for linked tables), but that is really the same issues regardless of whether you are using 32 or 64 bit. The driver must match the bitness of your OFFICE.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial