SQL 2005 to Ms-Access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL 2005 to Ms-Access

Author

Topic

S_Lakshmi
Starting Member

22 Posts

Posted - 2008-08-18 : 13:39:30

Hello,

I have created a linked server from SQL 2005 to MSAccess 2003. I ran the query

Insert into  Acc...artblCashRecBatch	Select * from CBREDB.REM.DBO.artblCashRecBatch

This is working fine. The same thing if i make into SQL server Agent job i am getting the following error


Executed as user: NT AUTHORITY\SYSTEM. Cannot initialize the data source object of OLE DB provider
 "Microsoft.Jet.OLEDB.4.0" for linked server "Acc". [SQLSTATE 42000] (Error 7303)  OLE DB provider 
"Microsoft.Jet.OLEDB.4.0" for linked server "Acc" returned message "The Microsoft Jet database engine 
cannot open the file '\\CBFAP\Chrisbanks\REM_ACCESS\REM_Prod.mdb'.  It is already opened exclusively 
by another user, or you need permission to view its data.". [SQLSTATE 01000] (Error 7412).  The step failed.

Could anyone please help me to get the solution

Thanks
Lakshmi.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-18 : 14:07:11

You should be running SQL server agent with domain service account and read/write permission on that network share?