Can Access 2010 Runtime 32-bit coexist with Office 2016 64-bit?

Bill Ross
Bill Ross used Ask the Experts™
on
Is it possible to run an Access 2010 accde created with 32-bit access on a computer where Access 2016 64-bit is installed by using Access 2010 runtime in parallel?  Can I install and call the 32-bit access runtime without messing up the 64-bit access 2016 install?

Thanks in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Technically, yes.  Different versions can coexist.  You can then create a shortcut or script to launch the database using a specific msaccess.exe.

On the other hand, why not simply make the database 64-bit compliant?
Bill RossProgrammer

Author

Commented:
Hi Daniel,

Thanks for the feedback.  

Suppose our db is C:\Test\Test.accde what would be the Access 2010 command line?

Regarding 64-bit compliance - the issue is that we have a 32-bit custom ActiveX control that has no 64-bit version and it crashes on 64-bit Access.  Now that MS Office defaults to 64-bit we are having issues.  With Office 2016 and 2019 installing the 32-bit is not trivial as before.

Bill
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
I don't believe it is, although I haven't tried it myself.

 Starting with A2013, apparently many of the same DLL's exist from version to version.   Prior to that, it was possible to have different bit installs in different versions, but starting with 2013 the rules changed (A2013 re-used some of the DLL's in A2010).

 I know for certain that it is possible to run A2007 in 32 bit mode, and anything after that in 64 bit.  But from A2013 and up, I believe it all needs to be the same bit version and that might include 2010

 Auto CAD posted a work around for the engine:

https://knowledge.autodesk.com/support/autocad/learn-explore/caas/sfdcarticles/sfdcarticles/How-to-install-64-bit-Microsoft-Database-Drivers-alongside-32-bit-Microsoft-Office.html

 But I don't know if that extends to Access itself nor how well this actually works.   I've kept all my clients on 32 bit and have avoided the issue for now.

 But if you do try it, as with any multi version install, make sure you put it in a different directory; do not use the default install directory.

Jim.
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Jim,

He's talking about installing 2010 runtime 32-bit side by side with 2016 64-bit, this should work.  No?
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
If you cannot make the database 64-bit as you said, can you use Office 32-bit.

With Office 2016 and 2019 installing the 32-bit is not trivial as before.

I am using Office 2016 32-bit. You should be able to uninstall Office (including the V2013 components), restart, and install Office as 32-bit.  See if that works.
I have installed O2010 aside O2016 previously, the only thing to be wary of is outlook, which should only have one version per device.
Bill RossProgrammer

Author

Commented:
Hi Everyone,

Thanks for the various comments.  I do not have control over which Office version the users install.  My app (accde) has been in production for 10+ years in over 100 locations but uses 32-bit ActiveX controls that have no 64-bit version so I'm thinking of installing Access RunTime 32-bit to make sure it works.  The current Office install now defaults to 64-bit so I'm having issues - thanks Microsoft...

The accde works OK on 2007 so based on Jim's posting, I'm going to fire up RunTime 2007 on my Office 2016 64-bit computer and see what happens.  I'll let you know.

Bill
Bill RossProgrammer

Author

Commented:
Thanks for your help.  Turns out we can run MS Access 2010 Runtime 32bit OK with Office 2016/19 installed as 64bit.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Surprised it works.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial