SQL Server 2012 Linked Server (MS Access) - Error: 109
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!
If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.