Forum Discussion
How to convert Access 32 Bit Database to Access 64 Bit Database
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.
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.
Sven Johannsen Thanks for catching that with runtime.
Actually, Microsoft is softening their stance on preference for 32 bit Office. By default now, when you install the latest versions (O365 and, I think also O2019) the 64 bit version is installed and it's a matter of sleuthing to even find the 32 bit option.
George_HepworthYea, that's why I said it the way I did. I still don't really see the benefit of 64bit for the average user. But then, the average user probably isn't using many add-ins that are only available with 32bit, so won't be harmed by installing 64bit either. Really only becomes an issue if you are creating DBs for others and are wanting to keep them from messing them up (accde ;) ). With Access coming with O365 instead of being $300 on its own per user, not as much incentive to use the runtime option.