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'.]

Use UNC rather than mapped drives to register databases. The reason is that while the mapped drive U may exist in your account, it may not in the account under which SQL Server runs. UNC (Universal Naming Convention) means using \\<machinename>\<sharename>\<path> eg:
\\fileserver\databases\northwind.mdb

regards
David Cameron

Hi, David!
Many Thanks! We shall try it here...
Regards!
VerdaFolio