JPG Image Stored

[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

 

[Guest]

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

 

[Arvin Meyer]

The sample Access 97 database at:

http://www.datastrat.com/Download/Picture.zip

will show you how you can store images efficiently outside your database and
still load them in the current form or report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access