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
chaitanya.dabholkar
SSC Enthusiast
Points: 115
More actions
November 3, 2009 at 9:35 pm
#1074661
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.