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.

 

[Uncle Gizmo]

Theres an example of how to do this on Rogers site:

From Rogers Site:
>>>>Pictures2k.mdb (161 KB) ( beginner ) Access 2000
It is usually preferable NOT to store OLE objects like pictures in the table itself. It causes massive database bloat. The usual solution is to store the pictures as files on the hard drive and store the file name in the table. This sample demonstrates how to to this.<<<<<