Forum Discussion
How to convert Access 32 Bit Database to Access 64 Bit Database
How to convert 32 Database created with 32 bit to Access 64 bit?
When I did it for experimentation, I just copied my 32bit .accdb onto a drive accessible from the system that had 64 bit Access on it and opened it with 64 bit Access. I had no issues. I imagine any library issues would have shown themselves. Can't say for certain what the .accdb became, or if it changed.
Another option if you want to be somewhat certain you are all 64 is to open a blank DB in the 64 bit version of Access and import everything, tables, queries, etc from the 32 bit .accdb. Tried that too and worked fine.
.accdb files are affected by 32/64 bit creation. However, .accde files are as they are essentially a 'compiled' verison of them and these do get locked to either 32 or 64 bit.
Hi, I have an issue with a db built in Access 32b.
When I open it with Access 64b, I get the following message. Is there any tools that can help at converting the code ?
Not really, no.
Actually, we should start by asking if you really MUST do this at all. Although it is possible to install the 64 bit version of MS Office, the most common advice is to use the 32 bit versions of MS Office. For Access, there is little or no benefit in converting to 64 bit. On the other hand, if you must have 64 bit Office in order to crunch enormous datasets in Excel, it's worth the effort to convert your Access APIs. Otherwise, not so much.
The solution is to manually convert all APIs in your VBA to use their 64bit equivalents. Here's a good place to start. Converting to 64 bit API
There may be other language versions of this page, so a search might turn up something useful as well.
