Database Size out of control

message from Kentucky5 on 11 May 2004

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

=?Utf-8?B?Sm9obiBXLiBWaW5zb24=?= replied to Kentucky5 on 11 May 2004

Access is *terribly* inefficient at storing any sort of graphics. It stores not only the image but also a bitmap - much bigger!

I'd suggest using WinZIP to separately send the PowerPoint presentation along with the database, and not store the images in the database at all.

=?Utf-8?B?Um9nZXI=?= replied to Kentucky5 on 11 May 2004

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

Kentucky5 replied to =?Utf-8?B?Um9nZXI=?= on 14 May 2004

I would appreciate that greatly, because this is getting
out of control.
find what exactly I did to fix this.
going to www.enterpriseprojectconsulting.com
email.

Archived message: Database Size out of control (MS Access)