This is a thank you to simonspring for finding this

"This additionally can cause issues:

http://stackoverflow.com/questions/8148774/error-quering-microsoft-ace-oledb-12-0-provider-from-sql-server

"

I remember running into an issue similar to this years ago with Advantage drivers.