Jpeg bloats access file size

G

Guest

Hello to all,

I'm using jpeg's for backgrounds inside my forms. Even though I have
optimized the graphics to a mere 42KB, once I import them into Access my
database file size increases a whopping 1MB for each jpeg I import.

Why is it that such a small graphic increases the file size of an .mdb by so
much?

-Sky
 
G

Guest

I believe the reason is that images are converted to bitmaps in the process
of importing them.

Tom
______________________________________

:

Hello to all,

I'm using jpeg's for backgrounds inside my forms. Even though I have
optimized the graphics to a mere 42KB, once I import them into Access my
database file size increases a whopping 1MB for each jpeg I import.

Why is it that such a small graphic increases the file size of an .mdb by so
much?

-Sky
 
G

Guest

Guys,

Thank you very much for your input on this. Jeff, that microsoft article
pretty much says access sucks when it comes to rendering objects. Maybe if I
convert the jpegs to a format access can handle it might make a difference.
At least I know whats going on though and again many thanks.

-Sky
 
M

Mark M

Have you tried leaving the image as an external file and then assigning the
path to an unbound image's Picture property? I use this method for a couple
of my forms to have a client's logo at the top of each form. It uses the
same 4k jpeg image for each form, so there's only one file that needs to be
in the database's folder. In the form's Open event, I use:
Me.imgBackdrop.Picture = CurrentProject.Path & "\FormBackdrop.jpg"
 
J

Jeff Conrad

in message:
Guys,

Thank you very much for your input on this. Jeff, that microsoft article
pretty much says access sucks when it comes to rendering objects. Maybe if I
convert the jpegs to a format access can handle it might make a difference.
At least I know whats going on though and again many thanks.
Click to expand...

Yes, Access does not handle graphics very well.
However, to be fair to Access, I do not believe that most
database systems handle them all that well either. Don't
quote me on that because I am not an expert on other
database systems.

Take a look around Sensei Stephen Lebans' site for various
techniques on how to handle image files. He can pretty much
make Access sing and dance just about any way possible.

http://www.lebans.com

Good luck with your project.
 
T

Tony Toews

Jeff Conrad said:
Yes, Access does not handle graphics very well.
However, to be fair to Access, I do not believe that most
database systems handle them all that well either.
Click to expand...

FWIW this made a lot of sense on 486's. It takes some CPU power to
decompress a .jpg. Which we don't notice these days. But back then
it was a lot faster to read a .bmp file and stuff it straight into the
video card memory.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
G

Guest

My reply posted at the bottom this time....



Tony Toews said:
FWIW this made a lot of sense on 486's. It takes some CPU power to
decompress a .jpg. Which we don't notice these days. But back then
it was a lot faster to read a .bmp file and stuff it straight into the
video card memory.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Click to expand...

______________________________________

Hi Tony,

Interesting that you brought this up. I mentioned several months ago, in
another totally unrelated thread, that I have the privilege of being a part
of a small team of people who is getting to look at parts of the next version
of Access currently in development.

I mentioned this very issue to the Access Development team members who were
present at one of these meetings, stating almost the exact same thing that
you just mentioned above; that the strategy of converting images to bitmaps
was useful back in the 386 & 486 days, but with today's faster PC's they
should provide for the capability of storing JPG's and GIF's without
conversion. Don't know if my suggestion fell on deaf ears or not....

Tom
 
J

Jeff Conrad

in message:

Hi Tony and Tom,

Very interesting Tony.
I had not thought about this before, but that does make perfect sense.
Interesting that you brought this up. I mentioned several months ago, in
another totally unrelated thread, that I have the privilege of being a part
of a small team of people who is getting to look at parts of the next version
of Access currently in development.
Click to expand...

What?!
Why am I not in this group?!!
Hummm....I suppose they do not want me drooling over everything.
That's understandable.
I mentioned this very issue to the Access Development team members who were
present at one of these meetings, stating almost the exact same thing that
you just mentioned above; that the strategy of converting images to bitmaps
was useful back in the 386 & 486 days, but with today's faster PC's they
should provide for the capability of storing JPG's and GIF's without
conversion. Don't know if my suggestion fell on deaf ears or not....
Click to expand...

Very interesting, Tom.
Thanks for the extra information.
 
G

Guest

What?!
Why am I not in this group?!!
Click to expand...

Hey Jeff,
If you are willing to commute from Bend to Redmond once a month, I'll see if
I can get you included. My commute is a lot shorter, as I live only about 3
miles from the main campus in Redmond. The other requirement is that you must
sign a non-disclosure agreement. One is allowed to talk about the fact that
they participate in such meetings, but they cannot divulge any of the content
of the meetings.

For the present time, our regular monthly meetings have been suspended until
further notice. The last regular meeting was held in November. We had one in
late Feb. too, but none since that time. I believe they will be picking up
again sometime in the summer.

Tom
______________________________________
 
J

Jeff Conrad

in message:
Hey Jeff,
If you are willing to commute from Bend to Redmond once a month, I'll see if
I can get you included. My commute is a lot shorter, as I live only about 3
miles from the main campus in Redmond. The other requirement is that you must
sign a non-disclosure agreement. One is allowed to talk about the fact that
they participate in such meetings, but they cannot divulge any of the content
of the meetings.

For the present time, our regular monthly meetings have been suspended until
further notice. The last regular meeting was held in November. We had one in
late Feb. too, but none since that time. I believe they will be picking up
again sometime in the summer.
Click to expand...

Very, very tempting Tom.

I'd probably pass out from all the excitement though.
"Security to the Access room please, security to the Access room."

;-)
 
T

Tony Toews

Tom Wickerath said:
The other requirement is that you must
sign a non-disclosure agreement. One is allowed to talk about the fact that
they participate in such meetings, but they cannot divulge any of the content
of the meetings.
Click to expand...

Ayup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

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

Similar Threads

Import Graphic vastly increases file size 2
Import Graphic into Word vastly increases file size 4
file size? 3
Embedding pictures 3
Bloating Access File Size 0
Access file size 1
Importing JPEG data into spreadsheet 4
Graphics on report 2

Top