Re: Is it possible to link tables with a relative path?

robinski@xxxxxxxxxxxxx wrote:
> I have failed to understand the method that I should use.
>
> I really am "getting started" and I am lost. I need step by step
> instructions please.

It is not possible to have a relative path in your links. It is possible to
refresh (or create) links via code (a somewhat advanced topic). It is also
possible in code to determine the location that the current MDB file resides in.
Combining those two produces code that can relink to all tables found in a file
in the same folder that the front end file resides in or a relative path from
that starting point.

If you want to experiment with this then see the code at this link...

http://www.mvps.org/access/tables/tbl0009.htm

While the code looks daunting you can "use" it without having to understand all
of the internal workings.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.