How to convert Access 32 Bit Database to Access 64 Bit Database

[ManojK365]

How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar

[#2]

You may like to review

https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/

But basically as explained by George and others, you can't do anything with the accde. It is compiled in 32-bit and is only good for running on 32-bit. You need to go back to the accdb file, address/fix any ActiveX controls, reference libraries, APIs, ... To their 64-bit equivalents and then recompile a new 64-bit accde and distribute that to your users. Everything depends on the complexity of your database.

As stated by others, if just stick with 32-bit unless there is a genuine reason to switch. In 99% of case, there is no benefit! If you use ActiveX controls, there may not even be a 64-bit version available and then you have to find another alternative altogether.

[#3]

https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/

But basically as explained by George and others, you can't do anything with the accde. It is compiled in 32-bit and is only good for running on 32-bit. You need to go back to the accdb file, address/fix any ActiveX controls, reference libraries, APIs, ... To their 64-bit equivalents and then recompile a new 64-bit accde and distribute that to your users. Everything depends on the complexity of your database.

As stated by others, if just stick with 32-bit unless there is a genuine reason to switch. In 99% of case, there is no benefit! If you use ActiveX controls, there may not even be a 64-bit version available and then you have to find another alternative altogether

[#4]

You cannot convert an mde!

You need the original mdb that was used as source to create the mde. You can compile the mdb to either a 32-bit mde with a 32-bit Access or to 64-bit mde with a 64-bit Access.

[#5]

@mustafiz salam sajib Can you build a database that works for both 32 and 64 bits?

[#6]

Depends. If you are going to just run the . mdb/accdb, yes, doesn’t matter. If you are planning to compile into an executable, no. The compiled version will look for compatible Office Libraries and they need to match. Same thing for additional Office programs. If you installed 32 bit Office, you can’t install 64 bit Visio. If you have the DB on a shared drive, you can open it in either 32or 64 bit Access. This is a pretty old thread though, so the prevalence of 32 and 64 bit Office installations may be different now.

[#7]

Thanks

[#8]

@Eric1890 

Yes, with conditional compilation it is possible. Additional reference. EXCELLENT VIDEO on 64 bit VBA. However, if your Access relational database application uses  32 bit activeX or third-party controls you can't run them under 64 bit Office. So, it does indeed depend on the specifics of the Access relational database application in question. Some will be compatible, some won't.