Instead of two versions of your app, it is better to use Compiler directives and define all you API references for 64bit and 32bit. You cannot have 32bit Access and 64bit Excel on the same computer. Though it is true that 32bit Office is recommended, there are good reasons to install 64bit Excel. MS Access 5 responses on “ MS Access – Database Created with the 32-bit version …” So yes, as a developer, if you are going to be distributing a database to users who have a 64-bit version of MS Access, then you need to also have a 64-bit version of MS Access.
Then you can distribute your database or convert it to an mde/accde format… Once you copy over the 32-bit version to the 64-bit version, Decompile the database, Compact and Repair, Compile (address any issue that may arise such as missing references, etc…) and finally Compact and Repair. So basically at the end of the day, you need to start maintaining 2 versions of your db: a 32-bit version and a 64-bit version. Make a copy of the 32-bit database and recompile on a 64-bit version of MS Access. I'm not surprised to get this error, but I'm not sure what do since I don't have a 64-bit version of MS Access 2016 nor does there seem to be available a 32-bit version of MS Access Runtime online. So right from the start, this is a bad idea! Earlier I was using Access Database Engine 2007 which was getting installed silently with quiet command. Please open it with the 32-bit version of Microsoft Access”.įirst let me state that it is not recommended to use the 64-bit of MS Access. I am trying to install Microsoft Access Runtime 2013 32-Bit silently using quiet property, but still it is showing the Installation UI window and asking to accept EULA. How can I find the registry keys of Runtime 64/32 bit.Have you ever developed a database using a 32-bit Access version and then tried to deploy it on a 64-bit version and receive the error: “This database created with the 32-bit version of Microsoft Access. The issue I am having is determining how I can tell what version of MS Access is installed 32 or 64 bit and if Access is even installed. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ Then I'll implement conditional statements like: reg query To check if a program is installed, I believe I need to use the reg query. I am currently building a batch file that silently installs MS Access Runtime based on multiple parameters.ġ.) If Runtime or Normal Access (that comes with Office Suite) is not installed, than the batch file installs a version of runtime based on the architecture of the computer (Runtime 32 bit or 64 bit).Ģ.) If normal MS Access is already installed do not install anything.ģ.) If MS Runtime is already installed do not install anything.Ĥ.) If Microsoft Office Suite (2016, 365) is already installed but does not include MS Access, install the version of Access Runtime that's the same architecture (64 bit or 32 bit).
0 kommentar(er)
