Question Link files

[duvenhlc]

Good day, I have created a database that display pictures on reports. The pictures is link to the databse and not stored internally. The database is split to a front and back end. I have the macro to reconnect the back end if the position of it change. My question, is there a way to keep track of these picture "file locations". If for instance someone make changes to the server or the server drive letter change, will I loose the link to the pictures. Is it posible to re-link this files. Was thinking that store the front part of the root, as aonce off and all other files will be linked.

Regards

Lance

 

[CraigDolphin]

The way I approach this is to save all the image files within a subfolder that is located in the root folder where the database itself is located. Then, I store the relative path to the file. Whenever I need to retrieve the full path to the file I simply concatenate the path to the database location (CurrentProject.Path) with the relative path and filename that was stored in the table.

It's one way to skin the cat. I'm sure others have solved the issue in other ways but it works for me. HTH