Hi there

Previously had a problem linking to Access v2k on SQL Server via
Linked Server. Submitted a question - no one answered. Well Solved
it.

Mistake was :-

1.Using Client Tools on Client p.c. to create linked server. Need to
do it via the SERVER. i.e. Enterprise Manager.

2.Need to share folder to allow access.

3.Path not e.g.

"D:\Program Files\Microsoft Office\Office\Samples\Name of db.mdb"

but

"\\workstation1\Samples\Name of db.mdb"

4.

querying server

e.g

SELECT field from NameOfServerCalled...NameOfTable

Hope this helps others.

ImraneA