We have an Excel application that utilizes Jet OLEDB 4.0 to interface with an Access database. It is a normal Excel file (.xls) with VB code behind the scenes that accesses the .mdb file. On Windows 8.1, using MS Office 2010, whenever a call to a function that needs access to the DB is made, I get an error:
Provider cannot be found. It may not be properly installed.
I tried installing the database engine for office 2010 (http://www.microsoft.com/en-us/download/details.aspx?id=13255) but it won't let me. If I try the x86 version, it says it can't install because I have Office 2010 Standard x64 installed.
When I try the x64 version, it won't install because I have Office 2003 Pro x86 installed (for MS Access). I don't know where else to get the Jet provider.
I did read about the MDAC, but that sounds like it's used for interfacing with non-Office platforms, not for communication from one Office program to another Office program, so I haven't tried that yet. Unless I'm reading that wrong? Do you think the MDAC might help?
I also read something about enabling 32-bit applications in IIS, but this is a normal workstation, not a server, and it doesn't even have IIS installed, so I don't think that's the issue.
Any advice is greatly appreciated. Thanks.