• This turns out to be a complicated subject. The first question is whether he is using the old .mdb format for his database, or whether he is using the new .accdb format? In the .mdb format, storing photoin an Access table is problematic if you have more than a few to store, as the database will grow by a significant amount for each photo. Access actually stores both the original .jpg as well as a .bmp format image. The usual solution to that is to store a link that gives the path and file name of the image and to dynamically load that information into an image control on a form when you want to view it.

    If he is using the new .accdb format, it still supports the old approach, but adds a new kind of field type called Attachment. This Microsoft Support Article goes into a fair bit of depth on how to use that type. However you should be aware that there have been some issues with that field type in early versions of 2007, so make sure your Dad has SP2 installed.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!