Determine if 32-bit or 64-bit version of Access is installed
Posted on 2013-05-24
I am distributing an Access based application using .accde files. My software first runs an executable created in Visual Basic 2010 which checks the version of the local file against the version on a network share and copies the file from the network share to a local folder if it is newer. The problem is that some of my customers have 64-bit Access installed and when they open the .accde file created in 32-bit access, they receive the message 'This database was created with the 32-bit version of Microsoft Access. Please open it with the 32-bit version of Microsoft Access.' I would like to be able to reliably determine in my visual basic program whether 64-bit Microsoft Access in installed so that I can copy the appropriate .accde file (64-bit or 32-bit) to the local computer. Is there a registry key I can look for or can I analyze the msaccess.exe file itself?