Linked server connection to MS Access db across the network failed

I have attempted to create a linked server on Server1 to an Access db on
Server2.
These servers are located on the same network.
The account running the SQL Server services on Sever 1 is a domain admin
account
I can open the file via explorer across the network using the same services
account.
The provider name I used is Microsoft.Jet.OLEDB.4.0.
The data source I used is \\(ip address)\c$\…\accessdb.mdb
I have tried with and without a security context of admin with no password.
I received the following error…
Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 13
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft Jet database engine cannot
open the file '\\(server)\c$\…\ accessdb.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
I realize this an issue of permissions. I am just not sure where the failure
is taking place, what the cause is, or even how to analyze it.
Also I am able to create the linked server if the access database is located
on Server1 with SQL Server. However this is not the scenario I am trying to
solution.
Please advise.
Thanks.
As I've referred in other posts ensure you've using correct version of Jet,
refer to KBA http://support.microsoft.com/kb/818182 and
http://support.microsoft.com/default.aspx/kb/241267 link.
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.
"IT4CABLETV" wrote:

> I have attempted to create a linked server on Server1 to an Access db on
> Server2.
> These servers are located on the same network.
> The account running the SQL Server services on Sever 1 is a domain admin
> account
> I can open the file via explorer across the network using the same services
> account.
> The provider name I used is Microsoft.Jet.OLEDB.4.0.
> The data source I used is \\(ip address)\c$\…\accessdb.mdb
> I have tried with and without a security context of admin with no password.
> I received the following error…
> Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 13
> OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
> [OLE/DB provider returned message: The Microsoft Jet database engine cannot
> open the file '\\(server)\c$\…\ accessdb.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.]
> OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
> IDBInitialize::Initialize returned 0x80004005: ].
> I realize this an issue of permissions. I am just not sure where the failure
> is taking place, what the cause is, or even how to analyze it.
> Also I am able to create the linked server if the access database is located
> on Server1 with SQL Server. However this is not the scenario I am trying to
> solution.
> Please advise.
> Thanks.