Error in Microsoft Access 2016

jodi-raegilbert · 2017-02-16T16:09:57.000Z

When one of my users opens Access databases via Power BI or otherwise, she gets the following error message:

Regardless of what options she clicks on, all her code and macros are removed.

If she clicks through and attempts action in the database anyway, she gets this error message:

She is running Windows 10 v. 1607 and has the latest version of the Office 2016 suite via Office 365. This started happening recently after a complete wipe and rebuild of her hard drive, even though she was able to use Access 2016 on Windows 10 previously with no issues. We tried opening the same databases with Access 2016 on a Windows 7 laptop, but we get the same errors.

I had opened a ticket with Microsoft, and, after asking a series of unproductive questions and then a 45 minute phone conversation, I was told by the Support staff that he couldn’t help me with my issue and that I post it on the Microsoft forums so that a forum specialist can help me. What?

I’m hoping someone here can shed some better light on this.

Thanks.

rockn · 2017-02-16T16:16:53.000Z

Open Access and go into the VB editor and look under Tools > References. See if the OLEDB provider in question is checked or even listed, If not you will have to add it and register it in references

Mike400 · 2017-02-16T17:20:59.000Z

Download and install the x64 version at https://www.microsoft.com/en-us/download/details.aspx?id=13255

jodi-raegilbert · 2017-02-16T18:48:20.000Z

Rockn, my user tried to do as you suggested, but the only she saw was something like OLEDB Error Library. She checked that option but didn’t attempt to open her databases.
Mike400, I then installed the Access Engine that you linked.
When we opened her databases, everything was working wonderfully. I’m not sure which one of your suggestions did the trick, but I’m leaning towards Mike’s download. It’s so sad that I spent days emailing and talking with Microsoft representatives, and they couldn’t resolve this issue. In just over an hour, you guys were able to steer me right.
This is why I love Spiceworks. Thanks so much.

ps. I wanted to mark a Best Answer and/or Solved, but I don’t see those buttons anywhere. Spiceworks seems to be acting funky in all my web browsers right now…

rockn · 2017-02-16T18:49:24.000Z

SW Broken again apparently

jodi-raegilbert · 2017-02-16T18:57:45.000Z

Ha, yeah, after I tried for five minutes in three different web browsers, I saw that Susan had just posted about the issues they were having.

In any case, thanks again guys.

rockn · 2017-02-16T19:04:55.000Z

Glad you have it working. Generally these errors happen between Access versions of what the original database was written in and the version installed on the computer. Some references are also deprecated between versions.