HELP PZE: HORRIBLE DATABASE SIZE WITH PICTURES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I am devleoping a database for my own company use. I've a product table
with an OLE filed to store picture. I've defined a few tables and the
databse size with 10 record in product table without pricture is about 232K.
Then I insert one 66K picture in JPEG format in the picture field (OLE) by
file, the database size go over 2M!!!! After inserting 10 Pictures, the
database size is around 50M already!

How can I solve this series problems????????????? Otherwise, I can't
use the database at all with this horrible size incresement with the
pictures?

Best regards,
Teres
 
At http://accdevel.tripod.com you can download sample databases illustrating
three approaches to handling images in Access, two of which are not subject
to the database bloat you are experiencing (and there's also an article in
the download explaining that bloat). Feel free to take and adapt any of the
sample for your own use... just don't expect any support, other than
newsgroup Q & A.

Larry Linson
Microsoft Access MVP
 
----- (e-mail address removed) wrote: ----

Dear all

I am devleoping a database for my own company use. I've a product tabl
with an OLE filed to store picture. I've defined a few tables and th
databse size with 10 record in product table without pricture is about 232K
Then I insert one 66K picture in JPEG format in the picture field (OLE) b
file, the database size go over 2M!!!! After inserting 10 Pictures, th
database size is around 50M already

How can I solve this series problems????????????? Otherwise, I can'
use the database at all with this horrible size incresement with th
pictures

Best regards
Tere


You may need to repair and compact the database. This is located under the database ultilities tab. The OLE type should not place the picture inside the database but a reference to the location.

I hope this helps.
 
Dear Mr. X,

It doesn't work. Someone explained to me it's the problem of access
will create a thumnail of bmp file for the OLE object field. I've tried to
link the file but it's the same. Someone suggested me to store the picture
as binary large object in the OLE field with some programming. I don't have
time to study the material as this moment. I've used the simplest way, not
the best way to deal with it - making the picture with lower resolution in
bmp format, around 320x240 pixels, which is around 230k.

If anyone have better suggestion, please let me know!

Thanks in advance!

Best regards,
Teres

Mr. X said:
----- (e-mail address removed) wrote: -----

Dear all,

I am devleoping a database for my own company use. I've a product table
with an OLE filed to store picture. I've defined a few tables and the
databse size with 10 record in product table without pricture is about 232K.
Then I insert one 66K picture in JPEG format in the picture field (OLE) by
file, the database size go over 2M!!!! After inserting 10 Pictures, the
database size is around 50M already!

How can I solve this series problems????????????? Otherwise, I can't
use the database at all with this horrible size incresement with the
pictures?

Best regards,
Teres


You may need to repair and compact the database. This is located
Click to expand...
under the database ultilities tab. The OLE type should not place the picture
inside the database but a reference to the location.
 
Just store the path and file name of the image file. You can retrieve the
image to display in a form or report.
 
hi teres,
we're having exact same problem, did you solve picture issue?

----- (e-mail address removed) wrote: -----

Dear Mr. X,

It doesn't work. Someone explained to me it's the problem of access
will create a thumnail of bmp file for the OLE object field. I've tried to
link the file but it's the same. Someone suggested me to store the picture
as binary large object in the OLE field with some programming. I don't have
time to study the material as this moment. I've used the simplest way, not
the best way to deal with it - making the picture with lower resolution in
bmp format, around 320x240 pixels, which is around 230k.

If anyone have better suggestion, please let me know!

Thanks in advance!

Best regards,
Teres

Mr. X said:
product table
with an OLE filed to store picture. I've defined a few tables and the
databse size with 10 record in product table without pricture is about 232K.
Then I insert one 66K picture in JPEG format in the picture field (OLE) by
file, the database size go over 2M!!!! After inserting 10 Pictures, the
database size is around 50M already! can't
use the database at all with this horrible size incresement with the
pictures?
Click to expand...
under the database ultilities tab. The OLE type should not place the picture
inside the database but a reference to the location.
 
It doesn't work. Someone explained to me it's the problem of
access
will create a thumnail of bmp file for the OLE object field.
Click to expand...

It's bigger than a thumbnail: it's a full-sized display in different
formats.
I've tried to link the file but it's the same.
Click to expand...

If it's still using the OLE field then it will be the (exactly) the same.
It's not the binary data that takes up the space, but the displayable
overhead.
Someone suggested
me to store the picture as binary large object in the OLE field
with some programming.
Click to expand...

That is pretty advanced, and I have never managed to make it work.

The most effective (only effective?) way to do this is to use a TEXT field
to store the filename and path to the graphic file, which should be stored
somewhere accessible on the server. Look at

<http://www.mvps.org/access/forms/frm0030.htm>

Hope that helps


Tim F
 
Back
Top