Hi,I am creating a linked server on my SQL 2008 on a server with MS Office 2007 installed. I ran the following :USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'ACCESS', @srvproduct=N'access', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'\\blmcik\AccesQuery\SwitchDatabases\switch measures.accdb'GO USE [master] GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ACCESS', @locallogin = NULL , @useself = N'False' GO
And I get the connection error saying:Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Access". (Microsoft SQL Server, error: 7302)I also ran the following with no success:USE [master]GOEXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1GOEXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1GO