Default Field Size question?

[Rednelle]

Greetings all,

Despite the inefficiency, I am content to cut and paste 20Kb JPEG images
into a OLEBound field in my inventory DB (because I don't want subsequent
users to have the hassle of loading and linking to other applications -
after my death).

I am surprised to see that the size of the Access mdb file increases by
about 1Mb for every 4 images added.

I don't suppose I will include more than 2000 images and the resulting
mdb file should fit on a single CD-R; no problem?

However, as a beginner here, I'm curious, is there any limit to the size
of an mdb file?

Is there some default (field / memory) size that I could safely reset to
a lower figure to store more images per Mb.

Kind regards

Tony E

[Pieter Linden]

"Rednelle" <re********@btinternet.com> wrote in message news:<cf**********@sparta.btinternet.com>...

Greetings all,

Despite the inefficiency, I am content to cut and paste 20Kb JPEG images
into a OLEBound field in my inventory DB (because I don't want subsequent
users to have the hassle of loading and linking to other applications -
after my death).

I am surprised to see that the size of the Access mdb file increases by
about 1Mb for every 4 images added.

I don't suppose I will include more than 2000 images and the resulting
mdb file should fit on a single CD-R; no problem?

However, as a beginner here, I'm curious, is there any limit to the size
of an mdb file?

Is there some default (field / memory) size that I could safely reset to
a lower figure to store more images per Mb.

Kind regards

Tony E

Search the NG for this one, or ask Larry Linson. Storing the images
inside your database is completely nuts. It will get enormous very
fast. If all of this stuff will be one the CD, use App.Path or
whatever to get the path to the MDB and figure out the path to the
images from there, and just store what you have to.

[Rednelle]

Thanks for the advice Pieter, I'll take it and contact Larry Linson

Kind regards

Tony E

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"Rednelle" <re********@btinternet.com> wrote in message

news:<cf**********@sparta.btinternet.com>...

[Larry Linson]

"Rednelle" wrote

Thanks for the advice Pieter, I'll
take it and contact Larry Linson

You just did. :-)

The example databases at http://accdevel.tripod.com (one for Access
97, a second for Access 2000 and later) illustrate three approaches to
handling images in Access, two of which do not cause the "bloat" that
you have observed. The included article explains why you see that
bloat.

I am away from my office machine with the exact hyperlink to MVP
Stephen Lebans' website, but you will find example code there to avoid
running out of memory when Reporting using other than .BMP image files
(it shows how to convert your files to BMP just before using them in
the Report). I believe you will also find a control to display images
if your users do not have the graphics filters installed.

Best of luck with your project.

Larry Linson
Microsoft Access MVp

[Pieter Linden]

la**********@ntpcug.org (Larry Linson) wrote in message news:<fc**************************@posting.google. com>...

"Rednelle" wrote

> Thanks for the advice Pieter, I'll
> take it and contact Larry Linson

You just did. :-)

The example databases at http://accdevel.tripod.com (one for Access
97, a second for Access 2000 and later) illustrate three approaches to
handling images in Access, two of which do not cause the "bloat" that
you have observed. The included article explains why you see that
bloat.

I am away from my office machine with the exact hyperlink to MVP
Stephen Lebans' website, but you will find example code there to avoid
running out of memory when Reporting using other than .BMP image files
(it shows how to convert your files to BMP just before using them in
the Report). I believe you will also find a control to display images
if your users do not have the graphics filters installed.

Best of luck with your project.

Larry Linson
Microsoft Access MVp

www.lebans.com

see, I told ya Larry would have that link... =)