JPG Image Stored

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

We are using Access 97.

We have created an OLE Linked Field for storing JPG
image. However, someone says that Access actually store
the image as BMP format. Is it correct ? We only want to
keep the database size small.

Besides, what is the best way to compact the database
backend at server regularly ?

Thanks
 
Access does indeed store the images as bitmaps, which leads to massive
database bloating.
The accepted method is to store your pictures on your server somwhere, and
have one of your fields contain a link to the picture, rather than storing
the picture itself.

The process to do this is quite long winded, have a look at the Access pages
at www.mvps.org they should provide you with a good starting point. If you
still need help, contact me through my website, and I will send you a small
sample database that you can customise for your own image handling.

Neil
www.nwarwick.co.uk
 
Back
Top