Link access database with sql server and run sql statment on sql-server
exec sp_addlinkedserver @server='AccessDb1',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\data\Categories_Products_Link.mdb'
exec sp_addlinkedsrvlogin @rmtsrvname='AccessDb',
@useself='false',
@rmtuser='Admin',
@rmtpassword=''
1 comment:
Post a Comment