Database Size out of control - 2nd Post

[Kentucky5]

Roger,
Have you been able to find the solution that you were
given for this issue?


Subject: RE: Database Size out of control
From: "Kentucky5" <[email protected]>
Sent: 5/14/2004 6:24:23 AM




I would appreciate that greatly, because this is getting
out of control.

-----Original Message-----
I had a similar issue a few months ago... I will try and

find what exactly I did to fix this.

I searched a lot of the knowledge bases but I ended up

going to www.enterpriseprojectconsulting.com

and they gave me the answer. I will see if I kept the email.

Roger
.

..
Subject: Database Size out of control
From: "Kentucky5" <[email protected]>
Sent: 5/11/2004 7:29:03 PM




I have one database that I have multiple pass through
queries to pull data in, that is not really the database
that I have the issue with although the size of that
database is still big considering what it contains.

I have another database that I email to a long
distribution list and I have compacted the database and
zipped it. But the actual database size is showing close
to 10mb which as you can imagine sending via email is
creating issues.

Now, let me explain. I have imported some powerpoint
presentations that contain pictures to be embedded in the
database. However, the size of these presentations are
extremely small, I manipulated the photo size so that the
size was not an issue or so I thought.

Any Help would be greatly appreciated.

If clarification is needed just let me know.

Thank you
..

 

[Arvin Meyer]

The bloat is caused by the way the database stores your images. You have
several choices. Store the images in an outside file and call them using the
Picture property of an image control. See sample code at my website:

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

Use a digital image control such as DBPix:

http://www.ammara.com

Or code similar to what Larry Linson has provided:

http://members.tripod.com/accdevel/imaging.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access