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,...