I am trying to create a linked server using the “microsoft office 12.0 access database engine ole db provider” as the provided to a linked database on a shared drive. The access database contains 50+ linked csv files which are updated daily through an FTP job. In the past, I was using the Jet 4.0 driver linking the directory and used with a schema.ini. Since I upgraded from SQL Server 2008 to 2012 I no longer have the option to use the Jet driver. When I test the new linked server connection the connection succeeds but when I attempt to access the tables through a query or through the object explorer window I get the error in the attachment. Any ideas on what might be wrong? Thanks experts!
Previous post has additional details: