Re: Make linked table have a relative path
- From: "Tanis" <dneagle@xxxxxxxxxxxx>
- Date: 31 May 2006 06:52:24 -0700
ghadley_00@xxxxxxxxx wrote:
Hi,
I have an access database with a table linked to an external text file.
Occasionally the location of the database and the text file change (but
are always in the same directory). Is there a way to have the location
of the external text file be a relative, rather than absolute path (to
be .\textfile.txt rather than C:\dir\textfile.txt)?
Any advice that can be provided would be provided would be greatly
appreciated/
Best wishes,
George Hadley
ghadley_00@xxxxxxxxx
If you link to a file on a local area network, make sure to use a
universal naming convention (UNC) path, instead of relying on the drive
letter of a mapped network drive in Windows Explorer. A drive letter
can vary on a computer or may not always be defined, whereas a UNC path
is a reliable and consistent way for Microsoft Access to locate the
data source that contains the linked table.
.
- References:
- Make linked table have a relative path
- From: ghadley_00
- Make linked table have a relative path
- Prev by Date: Re: Make linked table have a relative path
- Next by Date: Re: Unable to access folder from A2003
- Previous by thread: Re: Make linked table have a relative path
- Next by thread: Hide Query Output
- Index(es):
Relevant Pages
|
