ACCESS Link Tables

[Jay]

Is is possible to have access link tables to a relative path instead of an
absolute one?

For instance I have an ACCESS database which supports the application. I am
on a development machine linking Paradox tables to ACCESS. I want to be
able to copy from a link from one access database to another. This will
fail because the link is an absolute path not a relative one.

Is there anyway around this?

Any help toward this end would be appreciated and return a favor one day to
the next needing sole.

 

[John Nurick]

Hi Jay,

No, you can't use a relative path.

Sometimes using a UNC path (\\SERVER\SHARE\Folder\file.mdb) will let you
use an absolute path anyway. Otherwise, you need to re-link the tables
whenever the path changes. There's code at www.mvps.org/access and in
the Access Developer's Handbook (and elsewhere, I'm sure) to detect when
a linked table isn't available and let the user specify a new source.

Is is possible to have access link tables to a relative path instead of an
absolute one?

For instance I have an ACCESS database which supports the application. I am
on a development machine linking Paradox tables to ACCESS. I want to be
able to copy from a link from one access database to another. This will
fail because the link is an absolute path not a relative one.

Is there anyway around this?

Any help toward this end would be appreciated and return a favor one day to
the next needing sole.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Douglas J. Steele]

If you know the relative path to the backend database, you can always
determine where the frontend is located (CurrentProject.Path, or parse
CurrentDb.Name) and then modify the table linking code (such as what's at
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" so that it
doesn't have to prompt the user.

--
Doug Steele, Microsoft Access MVP

Hi Jay,

No, you can't use a relative path.

Sometimes using a UNC path (\\SERVER\SHARE\Folder\file.mdb) will let you
use an absolute path anyway. Otherwise, you need to re-link the tables
whenever the path changes. There's code at www.mvps.org/access and in
the Access Developer's Handbook (and elsewhere, I'm sure) to detect when
a linked table isn't available and let the user specify a new source.

Is is possible to have access link tables to a relative path instead of an
absolute one?

For instance I have an ACCESS database which supports the application. I am
on a development machine linking Paradox tables to ACCESS. I want to be
able to copy from a link from one access database to another. This will
fail because the link is an absolute path not a relative one.

Is there anyway around this?

Any help toward this end would be appreciated and return a favor one day to
the next needing sole.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.