none
Should Access Database Engine match OS install or Office install?

    Question

  • Hi,

    I have Office 2010 x86 version installed on Windows 7 x64 enterprise version. I have installed Access database engine x86 version.

    Now while tring to connect/ make connection to access database I am getting error "The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine".

    I tried installing Access Database Engine x64 version and then Office 2010 x86 version. But it is not allowing to install 32 bit version when there is 64 bit access database engine already installed.

    Should Access Database Engine macth OS install or Office install? If this is as per OS installed, then is there any way I can have Office 2010 x86 with Access Database Engine x64bit?


    Sameer Panse

    Saturday, June 25, 2011 5:21 AM

Answers

  • My library is an add-in for 64bit application. My library has a reference to MS Excel 14.0 object library. The operating system is 64 bit. Microsoft Office 2010 is 32 bit and Access Database engine is 32 bit. (I hope this is clear now).

    This is my connection string -

    strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + strDatabasePath + ";Persist Security Info=False;"

     

    When I try to connect I get an exception "The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine", though I have Access Database engine 32 bit.

     

    I searched on web and found out the passive switch option. I have installed AccessDatabaseEngine_x64 version with /passive switch and now it is working fine (Surprised?). I hope this (Having 32 bit Office 2010 and 64 bit access database engine) will not cause any problem.

     

    Any comments?

     

     


    Sameer Panse
    • Marked as answer by Sameer Panse Tuesday, June 28, 2011 6:29 AM
    Monday, June 27, 2011 1:41 PM
  • Please refer my post about passive switch installation. Considering this I think Access Database Engine should match OS installed. This is the way it works for me.

    Expert's comments please.


    Sameer Panse
    • Marked as answer by Sameer Panse Tuesday, June 28, 2011 6:30 AM
    Monday, June 27, 2011 1:45 PM

All replies

  • Do you have Office 2003 installed on the PC.  The ‘Microsoft.ACE.OLEDB.12.0′ is installed usualy with Office 2007 and later.  The Jet Engine will work with older verions of Office, but not have all the features that ‘Microsoft.ACE.OLEDB.12.0′ contains.
    jdweng
    Saturday, June 25, 2011 7:16 AM
  • Only MS Office 2010 x86 version is installed on the machine. There is no other office product installed except 32 bit access database engine 2010. Is it that Microsoft.ACE.OLEDB.12 provider comes only with x64 version of Access Database engine?
    Sameer Panse
    Saturday, June 25, 2011 7:33 AM
  • See webpage below

     

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

     

    You should be able to install the access database engine if you don't already have it.


    jdweng
    Saturday, June 25, 2011 8:12 PM
  • Sameer Panse wrote:

    I have Office 2010 x86 version installed on Windows 7 x64 enterprise version. I have installed Access database engine x86 version.

    I tried installing Access Database Engine x64 version and then Office 2010 x86 version. But it is not allowing to install 32 bit version when there is 64 bit access database engine already installed.

    Should Access Database Engine macth OS install or Office install? If this is as per OS installed, then is there any way I can have Office 2010 x86 with Access Database Engine x64bit?

    The Access Database Engine install should match the Office install.  The
    64 bit OS can run either.

    How were you trying to connect?   What was your connect string?

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Saturday, June 25, 2011 9:30 PM
  • Sameer Panse wrote:

    Only MS Office 2010 x86 version is installed on the machine. There is no other office product installed except 32 bit access database engine 2010. Is it that Microsoft.ACE.OLEDB.12 provider comes only with x64 version of Access Database engine?

    No, it comes with the x86 version.    Although I haven't tried
    installing just the Database Engine itself as I have Access 2007 and
    Access 2010 32 bit installed.


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Saturday, June 25, 2011 9:31 PM
  • My library is an add-in for 64bit application. My library has a reference to MS Excel 14.0 object library. The operating system is 64 bit. Microsoft Office 2010 is 32 bit and Access Database engine is 32 bit. (I hope this is clear now).

    This is my connection string -

    strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + strDatabasePath + ";Persist Security Info=False;"

     

    When I try to connect I get an exception "The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine", though I have Access Database engine 32 bit.

     

    I searched on web and found out the passive switch option. I have installed AccessDatabaseEngine_x64 version with /passive switch and now it is working fine (Surprised?). I hope this (Having 32 bit Office 2010 and 64 bit access database engine) will not cause any problem.

     

    Any comments?

     

     


    Sameer Panse
    • Marked as answer by Sameer Panse Tuesday, June 28, 2011 6:29 AM
    Monday, June 27, 2011 1:41 PM
  • Please refer my post about passive switch installation. Considering this I think Access Database Engine should match OS installed. This is the way it works for me.

    Expert's comments please.


    Sameer Panse
    • Marked as answer by Sameer Panse Tuesday, June 28, 2011 6:30 AM
    Monday, June 27, 2011 1:45 PM
  • Sameer Panse wrote:

    My library is an add-in for 64bit application.

    Presumably your add-in then is 64 bit?

    I searched on web and found out the passive switch option. I have installed AccessDatabaseEngine_x64 version with /passive switch and now it is working fine (Surprised?).

    Impressive searching.  I've never heard of that option and, as far as I
    can tell, it's not documented at Microsoft.   

    Any comments?

    Not from me.

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Monday, June 27, 2011 8:34 PM
  • This /passive switch has problems: if Office with Access 2010 32 bit is installed and if 64-bit ace is installed with /passive, then **every** time you run Access 2010, you get an automatic installation routine that resets to the 32-bit drivers for office.  Or at least I do.

    The situation may be different if you have office 2007 32-bit installed, as then there is less likely to be a direct conflict.  (microsoft could probably fix this....)

     

    Sunday, December 25, 2011 7:22 AM
  • Fascinating.    I am wanting to run my program on my SBS 2011 server and am having some conflicts and was trying to find out if these were the conflict.   Where did you install the AccessDatabaseEngine with the passive switch?   Was it on your server?   And how did you do it?
    Tuesday, April 09, 2013 9:04 PM