Minimizing Database Size with OLE objects

[McDeath]

Hi There.

I have an access database with the primary function of keeping all employee data. One of my brilliant managers has decided that a small photo must be added to each record. The company has almost 200 employees.

I have tried making use of different file formats for the photo's (*.jpg, *.bmp, even *.gif). And I have tried linking the photo's to reduce the size of the database. The database size has increased to an almost unmanageable level (i.e. 50 Mb). Without the OLE-Objects the database is 756 Kb.

Is there a way in which I can make the database smaller (i.e. the physical size on the disk)? Which file format (for pictures) works best? The database is a shared network resource so size really does matter.

Thanks

Christo

 

[GTLoco99]

Is the 50mb size after you compact the database. Sometime when adding features to the database, it will grow in size from the code changes and such. Compacting will sometimes get rid of some of the temp garbage and reduce the size. Also, 50Mb is not really that bad.

 

[McDeath]

I have compacted the database. This do not seem to have any effect on the database size.

The 50Mb mentioned would not have been such a big issue if the database is only used locally. However since this is networked database the size do have a very adverse effect.

Thanks for the help in any case.

Christo