Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: Linked Server Setup from SQL Server to a Microsoft Access Database

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: Fri, Apr 16, 2010, 3:05 PM


EXEC master.dbo.sp_addlinkedserver 
	@server = N'<span class='param'>NameOfNewLinkedServer</span>', 
	@srvproduct=N'Access', 
	@provider=N'Microsoft.ACE.OLEDB.12.0', 
	@datasrc=<span class='param'>FullPathToDatabase</span>', 
	@provstr=N'Microsoft.Jet.OLEDB.4.0'

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.