Forum Discussion
ManojK365
Feb 16, 2017Copper Contributor
How to convert Access 32 Bit Database to Access 64 Bit Database
How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar
Sven Johannsen
Brass Contributor
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.
grantpe
Jan 11, 2019Copper Contributor
.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.