Imbedded Pictures in a form

[davidrsutton]

Hi...

I have a database that is used as a catalogue. On each page is a short description of each item and a picture of that item. The Picture is an imbedded OLE object.

The problem is, having populated the catalogue with the pictures it is a huge .mdb file with each item taking up nearly 1Mb and it is clearly the images that are using up the space.

The size mode is 'Clip' and the area for the image to go into is no more than 16 x 9 cm and most of them do not even fill that. I am wondering if Access imbeds the images as a .bmp file. In which case, does anybody know how to either convert all imbedded pics to .jpg to cut down on space, or any other ideas that may drive down the size of this file, because before I know it, it will not be able to fit on a CD which is exactly what it needs to do!

Any ideas would be greatly appreciated.

Dave

 

[ZmrAbdulla]

See thread181-1178594

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[davidrsutton]

D'OH!

Cheers Zameer.

I'm guessing there is no way of resolving this without having to start again and input everythnig again.

Thanks again.

Dave