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\S amples\Name of db.mdb"
but
"\\workstation1 \Samples\Name of db.mdb"
4.
querying server
e.g
SELECT field from NameOfServerCal led...NameOfTab le
Hope this helps others.
ImraneA
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\S amples\Name of db.mdb"
but
"\\workstation1 \Samples\Name of db.mdb"
4.
querying server
e.g
SELECT field from NameOfServerCal led...NameOfTab le
Hope this helps others.
ImraneA