Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Microsoft ACE OLEDB pr...
Microsoft Dynamics GP (Archived)

Microsoft ACE OLEDB provider not registered

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

Ok, we are still getting no results on our migration from FRx to Management Reporter.

Once we got the MR Server and Client installed - after several hours - we then attempt to start the migration of the current FRx files and we encounter the following error when trying to run the Migration Wizard.

"Blue Box" states that :

Microsoft ACE.OLEDB.12.0 provider is not registered on this machine

****

We can see the companies in MR Legacy, we can see account details if we look in the row definition.  But when we try to run this Migration Wizard we are hammered with the error message.

We have 30 companies that need to be converted and we have over 100 reports

Any suggestions on what causes this error.

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Microsoft ACE OLEDB provider not registered

    Josh, I understand that Office is not a requirement for MR, but to be fair, the client is using the MR on a machine that is a Terminal Server as they have two executives out of the country that access the system remotely and there is no way to make GP / MR run on Web Client that we have figured out - so in addtion to MR  / GP they are also running Office apps.

    Not the best -- but only two users - so we figured it was worth the risk - all our other 'larger' MR users are running desktop access and we have had ZERO issues.  This was a weird issue and we had to make it work with what we had to work with.

    Your comments are correct and we do try to always follow the rules (?) recommendations, but this was a one off - hope -

    Thanks for the feedback and the links to the KB's

  • JoshP Profile Picture
    JoshP on at
    RE: Microsoft ACE OLEDB provider not registered

    Hi Bill,

    The MR services can use the Office drivers installed on a server; however, the version of Office that is installed needs to match the architecture of the server (same as MR). When you install MR to a 32-bit server, it installs all needed 32-bit files and drivers. When you install MR to a 64-bit server, it installs all needed 64-bit files and drivers. This is covered in the KB article below:

    2544472 Error message when you try to link to a Microsoft Excel Workbook in Microsoft Management Reporter:  "The Microsoft Access Driver, Microsoft.ACE.OLEDB is not registered"

    mbs.microsoft.com/.../KBDisplay.aspx;en-US;2544472

    It is a limitation of Microsoft Office that you cannot have a 32-bit installation of Office on a 64-bit server and install the 64-bit version of the Access Database Engine.

    Remember that you only need to install the Access Database Engine on the server running the MR services, not on any of the computers running the MR Report Designer client.

    As a side-note, please note that the Microsoft Office Support team has notified MR Support that installing the Access Database Engine using the /passive option is not recommended and may not be supported in a production environment, so this workaround is not included in KB 2544472. If you have questions on this, please feel free to contact the Office team.

    One last note is that you do not need a full Office installation on a server to export MR reports to Excel. MR has all of the information needed to do the export built-in. However, you would not be able to OPEN the exported files while logged into the server without Office.

    Hope that helps to clear things up!

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Microsoft ACE OLEDB provider not registered

    Josh it is too bad that the MACE drivers that are installed when you install Office Pro 2013 is not enough for the MR to use.  I am not sure why it mattered so much and it sure caused a challenge for everyone else in the office that missed using Office on the Terminal Server while we messed around with that.

    But looks like we are all good now.

  • JoshP Profile Picture
    JoshP on at
    RE: Microsoft ACE OLEDB provider not registered

    Hello Bill,

    Glad you were able to get this issue corrected. As Béat mentioned, the Microsoft Access Database Engine is listed in the System Requirements document for MR 2012 (www.microsoft.com/.../details.aspx).

    The Configuration Console will auto-detect if it is installed when installing the services, and will give you a warning if it is not installed. The Access Database Engine is a requirement for performing an FRx Migration or for including values in a MR report from an Excel workbook.

    Thanks!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Microsoft ACE OLEDB provider not registered

    Ok, this works for sure, after hours of pounding my head on the wall  - this works.

    Thanks Beat for the pointer in the right direction and thanks to the original post

    community.dynamics.com/.../42371

    (credit to bcool for the post) Edit Note: Skip right to the end of the Post - that is the answer!!

    Wish I found this prior to uninstalling Office 2013 Pro

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Microsoft ACE OLEDB provider not registered

    Yes those drivers... I don't have the reference files with me yet, I switched my work laptop this week and most of files and docs are still on my old system..

    Did you read this thread ? community.dynamics.com/.../42371

    Since FRx 6.7 was relying on Access DB engine, I remembered at the time we did the migration in 2012, that I ran the utility on the server directly. Fortunately it was a Win 2003 server 32bit, so they may have helped...

    Edit: Check the page 9 of MRforDynERPMigrfromFRxGuide_ENUS.pdf

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Microsoft ACE OLEDB provider not registered

    Which Access drivers are you referring to.  Are you talking about Access ones that appear at the installation of the Server and Client code?  I have downloaded that code and repaired the installation on the server a number of times - but it seems to make no difference  - do you know what version that should be?

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Microsoft ACE OLEDB provider not registered

    Hi Bill,

    Did you install the required Access drivers ? they are mandatory for the FRx migration utility...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans