Yes. I am able to access that folder from sql server. But the linked server connection to the mdb file gives the error

Its giving the same error.

Actually the Access database is residing under c:/ProgramFiles/A/B/C.mdb

So I am giving the data sourse name as \\AMPCSFDKW080\A\BC.mdb . Is there anything wrong here?

thanks

yes. You are right. I gave the username as the userid used to logon to the MS Access machine. Still getting the same error.

I am trying to connect to MS Access 2003 from SQL server 2000.

I followed this procedure

Exec sp_addlinkedserver

@server = N'VIMachine',

@provider = N'Microsoft.Jet.OLEDB.4.0',

@srvproduct = N'OLE DB Provider for Jet',

@datasrc...