source of the linked table

[sq75222]

In the object table, I can see there is a linked table but how do I know the
actual table located?

 

[Evi]

Go to Tools, Database Utilities, Linked Table Manager. The file path should
appear next to it
Evi

 

[Jerry Whittle]

SELECT MSysObjects.[Name],
MSysObjects.[Database],
MSysObjects.[Connect]
FROM MSysObjects
WHERE MSysObjects.[Type]=6
ORDER BY MSysObjects.[Name];

 

[sq75222]

If i want to change the linked table path,how should i do?

 

[Evi]

When you tick next to the Linked table, and click OK, if the original table
has moved, a File, Open box will appear so that you can browse to its new
location. If the original table is still in place you could delete your
current linked table and import it from your preferred location, ensuring
that you import it as a link.
Evi