Make linked table have a relative path

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

.

Relevant Pages

  • Possible to define a relative path for linked table
    ... 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 ... Any advice that can be provided would be provided would be greatly ... George Hadley ...
    (microsoft.public.access.externaldata)
  • Re: Database Listing and Sorting
    ... I am a rookie and just filling in) ... > I was wondering if someone could give some quick advice on how to modify the ... > This is coming from an Access database using ODBC so the 'GetRecord' ... > shorten the display. ...
    (microsoft.public.vc.database)
  • Re: Change Log On account in MS FW service - error 11004
    ... > These are W3C format on local drive, would like to configure it to SQL DB. ... > Please advice. ... Thx. ... Or in Access database? ...
    (microsoft.public.isa.configuration)
  • Re: OpenForm Action
    ... "McBride" wrote in message ... > I am using an Access Database that I did not create. ... But I am familiar with VBAs ... Tina's advice on how to track this down is good, ...
    (microsoft.public.access.formscoding)
  • Re: How to secure an Access database.
    ... To learn how to secure an Access database, check out the Access Security FAQ ... My advice is to read the entire document thoroughly several times, ...
    (microsoft.public.vb.database.ado)