Photo Database - getting too big

[Oscar]

I have a photo database where I go and link jpg files to a table in this database, then view them in a form with other details. The database is getting big in size very quickly. I have reduced the size of the photos but it doesn't seem to make any difference. I also periodically reduce and compact the database but is still huge and growing.

Does anyone know a more economic way to do this in Access?

 

[John.Woody]

Are you storing the pictures in the db, or storing the path to where the pictures are? The first will grow very quickly and not be managable, the second will reduce the size and be easier to administer if built correctly.