Saturday, September 6, 2008

Link connect Access Database with SQL-Server 2005

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:

mlee3680 said...
This comment has been removed by the author.