HELP PZE: HORRIBLE DATABASE SIZE WITH PICTURES

[Guest]

Dear all,

I am devleoping a database for my own company use. I've a product table
with an OLE filed to store picture. I've defined a few tables and the
databse size with 10 record in product table without pricture is about 232K.
Then I insert one 66K picture in JPEG format in the picture field (OLE) by
file, the database size go over 2M!!!! After inserting 10 Pictures, the
database size is around 50M already!

How can I solve this series problems????????????? Otherwise, I can't
use the database at all with this horrible size incresement with the
pictures?

Best regards,
Teres

 

[Larry Linson]

At http://accdevel.tripod.com you can download sample databases illustrating
three approaches to handling images in Access, two of which are not subject
to the database bloat you are experiencing (and there's also an article in
the download explaining that bloat). Feel free to take and adapt any of the
sample for your own use... just don't expect any support, other than
newsgroup Q & A.

Larry Linson
Microsoft Access MVP