Unviersal link to table (1 Viewer)

[dlugirapfr]

Hi,
is it possible to make short link to table in different access database ?
What I mean? Now when I connect table from different database these table has full link e.g. “c:\database\test.ascdbb” When I move this database to another folder it doesn’t work. Is it possible to create link to table I the same folder ? When I move folder with whole databases it will work in another localization.
Thank you for replay.

 

[isladogs]

This code will give you the relative path

CurrentProject.Path & "\database.name.accdb"

However you can't use that in the linked table manager.
You'll need to relink using code.

 

[Pat Hartman]

Here's a database with a form that shows a method for letting the users do their own relinking without using the linked tables manager.

 

[dlugirapfr]

Thank you for replays. Now I know what I have to looking for.