none
microsoft.ace.oledb.16.0 registry setting for TypeGuessRows location RRS feed

  • Question

  • Where is the setting for Microsoft.ace.oledb.16.0?

    It used to be at

    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\15.0\Access Connectivity Engine\Engines\Excel\TypeGuessRows

    But I see no entry for 16.0?

    Missing Registry Key

    


    Denis Cilliers BSc(Hons), MCDBA

    Monday, May 14, 2018 9:38 AM

Answers

  • Hi Pirlo

    Thanks for the tip on the 32bit vs 64 bit install

    The key is found here Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines\Excel

    Denis


    Denis Cilliers BSc(Hons), MCDBA

    Tuesday, May 15, 2018 2:52 PM

All replies

  • Hi Denis Cilliers,

    Please verify you have installed the ACE 16.0 completely on your machine.

    Then I guess you install 32 bit version of Excel on 64 bit machine, please have a check the property with following path:

    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\

    Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, May 15, 2018 2:06 AM
    Moderator
  • Hi Pirlo

    Thanks for the tip on the 32bit vs 64 bit install

    The key is found here Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines\Excel

    Denis


    Denis Cilliers BSc(Hons), MCDBA

    Tuesday, May 15, 2018 2:52 PM