Need Help! Problem illustrated as below.
NorthWind.mdb (MS sample) is located on a
remote drive (U:) thru network. There is
no access restrictions on it. But after
the Linked Server is built, we can never
access it. Error message follow.
Appreciate it if you can directly reply to
[email protected]
-----------------------------------
USE master
GO
EXEC sp_addlinkedserver
   @server = 'northU',
   @provider = 'Microsoft.Jet.OLEDB.4.0',
   @srvproduct = 'OLE DB Provider for Jet',
   @datasrc = 'U:\northwind.mdb'
GO

EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'northU',
@useself = false,
@locallogin = 'sa',
@rmtuser = 'admin',
@rmtpassword = NULL
GO

USE master
GO
SELECT * FROM OPENQUERY( northU, 'select * from shippers')

Server: Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find file
    'C:\WINDOWS\system32\NorthU'.]

try using the UNC instead of U: (ie. \\computername\share).