I have a large database with linked graphics as part of the records. The database also has a data access page so users without Access can view the information (reason for linked graphic files, since Data Access pages can't deal with OLE objects). I need to put the database on a CD, along with the graphic files, for distribution (it will be run from the CD, not from a hard drive so I can't have them install the files in the same path as I have them). As individual computers may have different CD Drive letters, is there a wild card for the linked file path that can be used instead of refering to a drive letter? Something like %CD%\{directory name}\{filename.jpg}?

If the DB is running off the CD you could use;

=CurrentProject.Path & "\" & [directory name] & "\" & [filename.jpg]