Viewing 2 posts - 1 through 2 (of 2 total)
Hi, We used to backup few SQL Server 2005 tables into MS Access file. The access file is accessed by using linked server.
sp_addlinkedserver 'AccessBackup', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', 'D:\Shaju\AccessBackup\InputDB.mdb'
sp_addlinkedsrvlogin 'AccessBackup', false,...
February 15, 2009 at 2:11 am
Hi, We used to backup few SQL Server 2005 tables into MS Access file. The access file is accessed by using linked server.
sp_addlinkedserver 'AccessBackup', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', 'D:\Shaju\AccessBackup\InputDB.mdb'
sp_addlinkedsrvlogin 'AccessBackup', false,...
February 15, 2009 at 2:10 am
Viewing 2 posts - 1 through 2 (of 2 total)