I have a 2003 Access database for tools. Besides the tool description, serial number, etc., I have a photo for each tool in a separate directory. The photos are saved by using the same [ToolName] that is in the database. I also have a [FolderPath] field. So, I need a way to display the JPEG using the [FolderPath] & [ToolName] in a Form and Report.
Bitmaps are not acceptable, so I don't want to imbed a bitmap into an OLE Object field. I also don't want to bloat the database with images.