What is the best to use in a db? JPEG / BMP / GIF?

G

Guest

I learned to use the OLE Object in the database table with a field called
picture. The same field is used in the input form for the table. I used a
query also with the field Picture (OLE Object) and it works just great with
the report.
So far I have only placed 5 images in the database which will have 93 more
when complete....so far the size is up to 39,952 KB. GOOD GRIEF....at this
level of growth, how can i possibly put in the remaining 93 pictures?
My question: Should I use / Can I use a smaller format of image, e.g. gif/
jpeg/tiff?
If so, how?
My pictures are in a separate folder on the "C" drive. The database uses
the OLE Object to place the "bitmap image" in the field in the
database....although as you know, the only place to see the image is in the
input form or the report.

Thanks to all who can give me a basic answer....I am a novice. I do not
understand writing code / sql / vba. Robert
 
D

Duane Hookom

At least one reply in tablesdbdesign where you asked the same exact
question. Please don't multi-post.
 
G

Guest

I figured the shotgun approach would ensure the most varied skills of
readers. Is this a violation? if so, sorry....just trying to learn and hear
from as many experts as I can.

RT
 
D

Duane Hookom

Many of us read through many news groups. I can't imagine how frustrating
this would be if a medium percentage of posters felt this was appropriate.
You can send a single posting to multiple news groups but even this isn't
appreciated by some.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top