I am trying to set up a linked server to an Access 2003 database. Here is my code and the resulting error. EXEC sp_addlinkedserver @server = N'Ariesdpo', @provider = N'Microsoft.ACE.OLEDB.12.0', @srvproduct = N'OLE DB Provider for Jet', @datasrc =N'\\tulstorage02\shares\share\IT\reserves\db\LPI RESERVES.mdb' GO -- Set up login mapping using current user's security context EXEC sp_addlinkedsrvlogin @rmtsrvname = N'Ariesdpo', @useself = N'false', @rmtuser = N'Admin', @rmtpassword = '' GO -- List the tables on the linked server EXEC sp_tables_ex N 'Ariesdpo' GO OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Ariesdpo" returned message "The Microsoft Office Access database engine cannot open or write to the file '\\tulstorage02\shares\share\IT\reserves\db\LPI RESERVES.mdb'. It is already opened exclusively by another user, or you need permission to view and write its data.". Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Ariesdpo".

Hello David, This is a SSRS forum, please post your thread into correct forum list below:- http://social.msdn.microsoft.com/Forums/en/category/sqlserver Thanks KumarKG, MCTS