--救命
EXEC sp_addlinkedserver
@server = 'srv_lnk',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'f:\my documents\客户资料.mdb',
@provstr = ';pwd=123'
EXEC sp_addlinkedserver
@server = 'srv_lnk',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'f:\my documents\客户资料.mdb',
@provstr = ';pwd=123'
EXEC sp_addlinkedserver
@server = 'srv_lnk',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'f:\my documents\客户资料.mdb',
@provstr = ';pwd=123'
你出現上面的錯是有可能你的@provider或@srvproduct錯誤。
這兩個的填寫是要看具體情況而定的