EXEC master.dbo.sp_addlinkedserver @server = N'AccessLinkedServerName', @srvproduct=N'Access', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'D:\Projects\MyAccessDB.accdb'
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'AccessLinkedServerName', @locallogin = NULL , @useself = N'False'
Thursday, October 7, 2010
Create linked server to Access 2007 accdb file
at 11:58 PM
Labels: Access, linked server, SQL Server, SQL Server Tip, T-SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment