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 = N'\\AMPCSFDKW080\A.I.T Co., LTD\CMT-SR2000NWR 7.0\SamInfo.mdb'

Go

EXEC sp_addlinkedsrvlogin

@rmtsrvname = N'VIMachine',

@useself = N'false',

@rmtuser = N'Admin',

@rmtpassword = ''

GO

But when I try to see the table in Enterprise manager I am getting the error

Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported an Erroor

thanks