Database Size Getting Large

[Ty]

I have a database with approximately 150 records. The problem is it is
getting very large - currently 1.7 Gig, and growing.

I have two fields so I can put two pictures in for each record.

The problem is I have not add two pictures to each record and I am already
at 1.7 Gig.

I need the pictures - so getting rid of the pictures is not an option.

Is there something I can be doing to keep the size down?

Thanks !!!!

Ty

 

[Douglas J. Steele]

You may need the pictures, but you don't need to store them in the database.

Access is extremely bad about storing images. The normal recommendation is
to store the pictures external to the database and strictly store the
details of where the picture is stored in the database.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.