Search code examples
vbams-accesswindows-server-2012

MS Access 32-bit or 64-bit


I have created an Access 2016, 32-bit application that is about to be deployed. Every user will access the application through a RDP connection and then onto a MS Server 2012 R2 server (I doubt if it will ever be installed on any other platforms). As far as each user is concerned there will be nothing on the server, except the Access database (using an Access runtime license), and each machine will be pretty much locked down.

All of the libraries used in the Access application are available in either 32-bit or 64-bit formats, plus the back-end databases are usually small (typically between 10MB and 200MB). That said the compiled Access front-end is about 18MB and can run some rather complex functions/calculations (but nothing on a scientific level).

So finally, my question. Would there be any real benefit in moving to a 64-bit version (in either the short or long-term)?


Solution

  • Short answer: No. 64 bit version doesn't give any useful advantages, but you will have some additional problems with compatibility.