Converting MS Access "OLE Objects" back to plain JPEG files - the best way?

Question

Converting MS Access "OLE Objects" back to plain JPEG files - the best way?

Background: we have an old (but critically important for business) SQL Server database with the MS Access ADP interface; it was originally optimized for SQL Server from the Access database series.

This database tracks hazardous materials for our customers and stores a large number of images. These images are inserted from MS Access and inserted into the database as OLE objects.

Problems:

This is a pain that can be read in everything except Access / Office
There MASSIVE storage overhead - ~ 10 GB of images takes up more than 600 GB of storage space (!)

My question is: how could you recommend converting these bloated objects back into plain JPEG files? Once we do this, we can finally transfer our interface from Access to a simple web-based system, and our backup time will again be manageable!

+5

image ms-access

Keith williams Sep 22 '08 at 11:28

source share

4 answers