S
sq75222
In the object table, I can see there is a linked table but how do I know the
actual table located?
actual table located?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Evi
Go to Tools, Database Utilities, Linked Table Manager. The file path should
appear next to it
Evi
appear next to it
Evi
J
Jerry Whittle
SELECT MSysObjects.[Name],
MSysObjects.[Database],
MSysObjects.[Connect]
FROM MSysObjects
WHERE MSysObjects.[Type]=6
ORDER BY MSysObjects.[Name];
MSysObjects.[Database],
MSysObjects.[Connect]
FROM MSysObjects
WHERE MSysObjects.[Type]=6
ORDER BY MSysObjects.[Name];
S
sq75222
If i want to change the linked table path,how should i do?
E
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
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