Problem linking ACCESS to SQL SERVER

Hi,

I have an access database that I want to link to SQLServer. For this, I want
the service where SQLServer is running under, to only have rights to READ th
e
mdb file. The NTFS and share settings are set accordingly.

This works fine on one server:

EXEC sp_addlinkedserver
@server = 'TEST',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc =  '\\myserver\myshare\
test.MDB'
GO

EXEC sp_serveroption 'TEST','use remote collation','FALSE'
GO

SELECT * FROM TEST...[my access table]

BUT... on another server this doesn't work, and I receive the following erro
r:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft Jet database engine can
not
open the file  '\\myserver\myshare\
test.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::Initi
alize returned 0x80004005:   ].

I am 100% sure that no one is using or locking this database.

Does anyone have some ideas?

Thanks,
Jan