Access Runtime with JPEG Images

[dkmarsh]

I have developed a Real Estate Listing system that allows Real Estate Agents to store their property listings.
Each property listing will have at least 1 JPG photo attached to it.
I started off using Embedded OLE objects, but the database grew really fast due to the "bloat" problem that access has with JPEG photo's.
I then changed the photos to a linked image, where the JPEG photo is saved into a directory and loaded when requested.
THis works ok, however there are 2 problems
1) If you click too quickly between properties on the property form, Access will crash.
2) Access needs the Microsoft Office JPEG filters installed on the machine in order to display the photo's. The Access runtime install does not install this filter. It is installed with Microsoft Word and other office products, however not everyine will have this installed on their machine.

I would really appreciate advice on how to get around these problems.

Thanks

 

[Tim K.]

Check this link, Image Control may cause a GPF when browsing between records for the first question.

I would use Bitmap format instead of JPEG. You can convert 100s JPG files to BMP by using ACDSee in a few minutes.