Why does OLE Objects takes up some much space?

[Hosacans]

Hi All,

I am working with jpeg images in an Access database using OLE objects. i notice that once i paste an image onto a record, the actual memory size of the database becomes bigger. The database grown substantially as i continue to import more images. This is causing a problem because it's taking a much longer time to compact the database. and I also notice degraded performance in generating reports.

If anyone can provide some explanation on why this is happening, or if there's another way to post images in reports. it'll be much appreciated.

Thanks
Hosacans

 

[fneily]

Let's see - images are usually a meg or so, times 10, etc. Yeah, the database will grow. This is why you DON'T keep images in an Access table. You keep the path name to the image.
See:
thread702-289543

By the way, if you do alot of redesigning and deleting, the database will also grow. So get in the practice of doing a Compact and Repair quite often.

 

[Hosacans]

Thanks fneily, for the directions... the thread you posted is exactly what i am looking for. Now on to study the wisdom of scriverB!