Home Forums Programming Connecting SQL Server 2005 - how so I create a linked server to Access 2007 RE: SQL Server 2005 - how so I create a linked server to Access 2007

  • In SQL Server, go to Providers object, right click on Microsoft.ACE.OLEDB.12.0 and select properties, then put a check on Allow inprocess.