The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

[Former user]

After using MODSIM for a long time, higher versions than the 8.4.1 show me this error: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" and the graphs and results are not shown after the network runs.

Now I can't find this version's (8.4.1) setup file to install it in another computer.

If anyone could help me out with this it would be very helpful.

My e-mail is: [e-mail]

Thanks.

[Amanda Hoff]

I am having this same issue. Did you ever figure out how to solve this issue?

Thanks!

[Bob Lounsbury]

This is either caused by a mismatch between the build architecture of MODSIM and Microsoft Access, or Microsoft Access is not installed and so the Microsoft Access Database Engine is not installed. In the first case, Microsoft Access is installed, ensure the build architectures match. If you have the 32 bit version of Microsoft Access installed then install the 32 bit version of MODSIM. If you have system requirements that force different build architectures there are instructions in the Wiki on how to deal with that. In the second case, Microsoft Access is not installed, you’ll need the Microsoft Access Database Engine, though this hasn’t been truly tested.

[Amanda Hoff]

Thank you for the quick reply! I do have Microsoft Access (32 Bit), so I downloaded and tried to run the 32 bit version of MODSIM. When I attempted to open the program, nothing happened. I am not sure if I have something on my machine that is blocking it from opening? I also attempted to download and run the 64 bit version, which would open, caused the initial error ('Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine). I did see in a forum where it was recommended to run the Microsoft Database Engine, so I tried that as well, but it still did not fix the issue. Our IT person will be in tomorrow, just trying to get some information on what might be causing the 32 bit version of MODSIM to not open when I click on the application. Thank you for any additional information that you may be able to provide.

[Amanda Hoff]

This is my current Microsoft Access build.

‌

[Bob Lounsbury]

Given that you have Access 32 bit you’ll need to use MODSIM 32 bit to generate an Access output file without further hacking. Maybe try starting the program from the command line, C:\Program Files (x86)\CSU\MODSIM 8.5.1\modsim.exe, and see if any further info is shown. Or maybe a fresh install and reboot your machine. If not, hopefully your IT person has some ideas as I’ve never heard of MODSIM not opening. Are you on a 32 bit processor and 32 bit operating system?

[Amanda Hoff]

I am on Windows 10 and I believe it is 64 processor/64 OS. Not sure why I have Access 32 in the first place. I will work with our IT person tomorrow and try to get that upgraded. Thanks for your help!

[Enrique T]

It seems like recent updates to MS-office is causing this error to show up even if the ‘matching’ versions of MODSIM and office are used. Installing the corresponding version of the MS-Access engine seems to solve the issue. Since you need an older version of the engine, the system will allow installing it, even though you might have a newer version of the engine installed as part of office. We have seen successful resolutions of this issue installing the AccessDatabaseEngine2010 (https://www.microsoft.com/en-us/download/details.aspx?id=13255). Use the version (32 Vs 64) that matches the MODSIM version you would like to run.

We are working on an SQLite alternative for output format that don’t use MSAccess engine to avoid these issues. Stay tuned.

[Kasra Keshavarz]

I am wondering if the SQLite version of the MODSIM is released yet?