Forum Discussion
How to convert Access 32 Bit Database to Access 64 Bit Database
Thanks for information but I still have the same problem
And which problem would that be? Are you trying to convert from a 32 bit to a 64 bit environment? If so, there are differences in the way you need to handle API calls. 32 bit ActiveX controls won't work in a 64 bit environment.
Or is the issue related to creating an accde from one or the other?
Thanks for clarifying.
- Mohammed_S_SafiMar 31, 2019Copper Contributor
Hello George Hepworth
Thanks for replaying the problem is like this:
there is a file created by the author in access type of extension is .accde they created in 32 bit version,
when I try to open it in 64 bit version not work since my laptop is 64 bit
I follow the instruction that written before but it still not work
- George_HepworthMar 31, 2019Silver Contributor
Mohammed_S_Safi Thanks for clarifying.
Accdes must be created using the same version and bitness of Access as the one you will use to run the accde. So, you must start with the original accdb for this MS Access database application. Make sure it runs properly as an accdb on the laptop where you will use it--the one with 64 bit MS Office. Then, when it is all ready, convert that accdb to the accde which will then run on your laptop.
- Sven JohannsenMar 31, 2019Brass Contributor
The first question that must be asked is whether you have Access on your laptop. If you are trying to run the accde with the Access Runtime, it will only work with the same bitness. As was mentioned a 32bit accdb will run under 64bit Access, though there may be some adjustments that need to be made depending on what is called in VBA.
There is no reason you need to install 64bit Access on a 64bit laptop. For the longest time MS even recommended you did not install 64bit Office on a 64bit machine unless you really had a specific reason (huge spreadsheet, project files). Is it reasonable to remove the 64bit Access (or Office) and install the 32bit in your case.