Hello all,
I am trying to create a database that uses image files and the path to the image file is stored in a field of a table. My issue is is that I keep the file on a flash drive and when I work on this at home, the drive has 1 location ie. H: and when I work on it at work it will have another location E: so all of the paths are incorrect. Is there a way to find out the location of where the database was loaded from then use that as the starting location for the image files.
Example Work: Work Laptop Database is Located on Flash Drive and has location of E:\ Login\Pictures\Image1.jpg
Example Home: Home Laptop Database is Located on Flash Drive and has location of H:\ Login\Pictures\Image1.jpg
Is there a way I can grab the location of the database starting point then just append that with the Image file name?
That way, no matter what the drive letter is it would always find the image file.
Does that make sense?
Thanks
Dave