RELATIVE PATH IN A FIELD

[jrmellis]

I am displaying some images which are stored outside of access in a form. The path to these images are stored in a field and swapped in when needed. Is there a way to specify a relative path so that it changes if I move the database to say a CD-ROM?

 

[jatfill]

If you're just embedding an image on a form/report, put the image in the same place as the database file(s) and drop everything but the file name from the path (Access 2000-XP, I'm not sure if 97 will do this). When you relocate, it should come right up. I do this with pretty much every database to avoid relocation issues. The custom icon is the only image I know of that requires the full path, but even that can be set at runtime through VBA...

 

[jrmellis]

Thanks, much.