Creating Access Link Database on Sqlserver2005

Posted: March 26, 2008 in Sqlserver

EXEC sp_addlinkedserver
@server = 'AccessDB',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\grvv7600\wwwroot\Timekeeping\Timekeeping_Data_Store.mdb'

Advertisements

Comments are closed.