Inserting jpeg instead of bmp

S

SorryTo Ask

I have a form that requires an ole to be inserted. These are usually pics
for the various projects. Is there a way of loading jpegs (these files are
usually smaller) rather than bmp. When I print a report to PDF I find with
several pics embedded that the resulting file is too big.
Hope all that makes sense.
John
 
A

Arvin Meyer

Please ask in appropriate newsgroups. Queries can in no way be related to
your question. I've truncated the groups to relevant ones.

You can insert most image formats, but the resulting Access database will be
much larger, not smaller. That is because the bmp format is the native file
format and Access stores everything that way anyway. To reduce file size you
may want to store your images outside of the database and use a link to the
database in the table to open the image as appropriate.

An example of this is the PictureMgr demo database at my website:

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

It contains all the code you'll need. You can even copy any paste the forms
and code into your own database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
L

Len

I had a simular situation about 3 yearsd ago. What I did was put the name of
the jpg in a field in a record. I then added relationship so that the two
records would have a one to one relationship. I hope this will help with
your situation and that it was the same as mine.

Good Luck

Len
 
Top