Sql Server建立链接服务器访问Access的MDB数据库

EXEC master.dbo.sp_addlinkedserver
@server = N'test',
@srvproduct=N'OLE DB Provider for Jet',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'E:\DB.mdb'

EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = N'GH',
@locallogin = NULL ,
@useself = N'False',
@rmtuser = N'admin',
@rmtpassword = N'pwd'

转载于:https://www.cnblogs.com/hz-blog/p/4897766.html