I cannot create a Linked Server from my desktop, although have no problem creating it
on the server itself.

Specifics:

Server: NT4.0, sp6; SQL2000; my role is SysAdmin;
MyPC: Win2000; SQL 2000; my role is SysAdmin;

procedure (trying to link to an MS Access db; PUBS is listed here as an example):

sp_addlinkedserver 'AccessPubs', 'jet 4.0', 'microsoft.jet.oledb.4.0', '\mypcsharedirpubs.mdb',
null, null

When I try to view table names, I get a MsgBox: Error 7399. 'Microsof.Jet.OLEDB.4.0 reported
an error'

When I run the same procedure (sp_addlinkedserver ) locally on the Server,
I successfully create a linked server and can view tables on both the Server and on MyPC;

Am I missing something obvious?

Thanks,
Boris