How can a relative path specify a linked table in Access 2007?

user_117700 0
Viewed 23575

I have a front end and back end of an Access database. The front end references linked tables and I need to do a relative link instead of an explicit one i.e. "../database" is referenced instead of "address/database"

Is it possible to do this, or must I specify the absolute path?

ms-access
6 Answers

you can make a "calculated" field.. works for me in Office Access 2016

"F:\Komponenten\Datenbank\Bilder\" & [Kategorie] & "\Pinout\" & [Bezeichnung] & ".jpg"

maybe there are better solutions, see images

calculated path result

user_144635980
Related