Storing Pictures In Access

[Walshy99]

I have created a database for properties, and have included images. There are 10000 properties, each property will have two images. The problem is the size of the database, so far with just 20 images in the database, the size is 310mb (After compacting the database).

Is there a better way of achieving this

 

[jrbarnett]

Hi,

Have you considered storing just a text field with a path to the image, which can then be loaded dynamically from an external disk file? If you need to display it on forms, you can include it as a linked rather than embedded.

John