I am not sure of the terminology, but how do you 'create relative paths' for pictures in a database. Presently I have the full path (c:\my\picture\picture.jpg) to the image stored in a text field within the .mdb, but when I distribute the .mdb to others I have (or they have) to change the directory to reflect where the file structure is located on their system.
The file structures are the same; it's the dir that are different.
How can I set up any .mdb so that I can store just the relative path (picture.jpg) in the mdb and not have to change C:\ to F:\ or V:\ etc., when I pass the .mdb to someone else to test.?
Thanks!

The file structures are the same; it's the dir that are different.
How can I set up any .mdb so that I can store just the relative path (picture.jpg) in the mdb and not have to change C:\ to F:\ or V:\ etc., when I pass the .mdb to someone else to test.?
Thanks!
