none
How I can install Access Database Engine without uninstalling Microsoft office? RRS feed

  • Question

  • I have windows application in .Net working with excel file in memory, with windows 32 bit  it's work propperly , but with windows 64 bit i have to install Access Database Engine to connect with excel file.
    when you want to install Access Database Engine , there is error message tell you " you have to uninstall office 32 bit  to compleate " this is my big problem how i can tell  my customer you have to uninstall office to install my application ..... any solution plz....
    SO I want to install Access Database Engine without uninstalling Microsoft office?
    Tuesday, April 10, 2012 4:51 PM

Answers

  • Hi AymanKrosh,

    Welcome to the MSDN forum!

    If you have a 64 bit machine and have Office 32 bit installed, you can try to download the 32 bit version of the Access Database Engine.

    Please try the following link, which focus on Office 2010:
    Microsoft Access Database Engine 2010 Redistributable
    http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

    Launching the install of a Microsoft ACE OLEDB Provider on a machine with an Office install other than the current one (e.g. 32 on 64) will cause the install to fail. To have it run properly you need to launch it from a command line with the “/passive” argument specified.

    • To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit:

    $> AccessDatabaseEngine.exe /passive

    • To install the Microsoft ACE OLEDB Provider 64-bit on a machine running Office 2010 32-bit:

    $> AccessDatabaseEngine_X64.exe /passive

    Hope it helps.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us


    Thursday, April 12, 2012 7:22 AM
    Moderator
  • Yes ... I get it

    I will put it in .bat file and run a bat file during installation

    Thanks for All

    Saturday, April 14, 2012 8:40 AM

All replies

  • The ACE engine is available on Microsoft's download site as a standalone package.  http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255
    Tuesday, April 10, 2012 9:04 PM
  • Yes, but when you want to install this package the error message will appear tell us to remove office 32 bit before this installation !!!!
    I want to install it without removing office.
    Wednesday, April 11, 2012 7:11 AM
  • If I remember correctly, the Access Database Engine is only required to access Excel 2007 (and higher) files.

    Have you tried to install the 32bit version of the Database Engine?


    The Data Specialist (Blog)

    Wednesday, April 11, 2012 8:27 AM
  • I installed ... as you see there is no provider:

    any advice... with thanks

    Wednesday, April 11, 2012 9:51 AM
  • so, if you have the 64 bit version of office and the corresponding ACE driver installed, you can install the previous version of the 32 bit ACE driver (for office 2007), but this is not a supported scenario. Furthermore, I've noticed that this set up may not work as you want it to for certain applications.  I used to have both the Office 2007 32 bit ACE driver installed alongside the Office 2010 64 bit ACE Driver, and after SP 1 dropped, some applications were not able to use the 32 bit version any longer.

    So that is a long winded explanation, but do you have any x64 versions of office installed on any machines?  If all copies of  office are 32 bit, then change your .NET app to target x86 and not AnyCPU.

    Wednesday, April 11, 2012 6:31 PM
  • Hi AymanKrosh,

    Welcome to the MSDN forum!

    If you have a 64 bit machine and have Office 32 bit installed, you can try to download the 32 bit version of the Access Database Engine.

    Please try the following link, which focus on Office 2010:
    Microsoft Access Database Engine 2010 Redistributable
    http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

    Launching the install of a Microsoft ACE OLEDB Provider on a machine with an Office install other than the current one (e.g. 32 on 64) will cause the install to fail. To have it run properly you need to launch it from a command line with the “/passive” argument specified.

    • To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit:

    $> AccessDatabaseEngine.exe /passive

    • To install the Microsoft ACE OLEDB Provider 64-bit on a machine running Office 2010 32-bit:

    $> AccessDatabaseEngine_X64.exe /passive

    Hope it helps.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us


    Thursday, April 12, 2012 7:22 AM
    Moderator
  • Sorry for the delay in a reply
    Thank you for your efforts ... wonderful Solution...
    Now, can we embed "AccessDatabaseEngine_x64.exe" setup in my main program installation or in my main project setup ( my program in VB.Net ) and execute this line "$> AccessDatabaseEngine_X64.exe /passive" In order not to occupy the user?

    with thanks.

    Saturday, April 14, 2012 7:09 AM
  • Yes ... I get it

    I will put it in .bat file and run a bat file during installation

    Thanks for All

    Saturday, April 14, 2012 8:40 AM
  • Thanks for this - it solved my issue. But everytime I open Excel, a dialog pops up "reconfiguring" excel (it takes about 40sec to complete; that is painful).

    After scouring the web, I found this solution to the reconfiguring dialog - it is to remove the MSO.DLL from registry:

    "

    Delete or rename the "mso.dll" registry value in the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPath

    "

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

    I'm not sure what the impacts are...and definitely not a fan of hacking registry like this.

    Is there another way of silencing that reconfigure dialog, or am i missing something about the passive installation?

    THanks!

    Tuesday, October 11, 2016 1:44 PM
  • Thanks.

    I have cloud 32-bit version of 2016 excel and 64 bit windows and this worked for me.


    chipsy

    Tuesday, March 5, 2019 7:28 PM