File size 20x larger than expected

[Guest]

Hi, a student of ours is currently creating a simple DB using Office 2003 SP1
on WinXP. Her classmates are doing very similar DB's which are all around the
2MB mark. This one student however, has a DB of 43MB and rising. She has no
complex images in, and only 5 or 6 in total.

Today she added 2 x 200KB images, and the DB size went up 10MB.

I have tried to compact the DB with no luck. I tried removing some images
but still the file size did not reduce at all.

Any advice appreciated as this student is fast fillling her network disk
quota !

Thanks in advance.

 

[Joseph Meehan]

Hi, a student of ours is currently creating a simple DB using Office
2003 SP1 on WinXP. Her classmates are doing very similar DB's which
are all around the 2MB mark. This one student however, has a DB of
43MB and rising. She has no complex images in, and only 5 or 6 in
total.

Today she added 2 x 200KB images, and the DB size went up 10MB.

I have tried to compact the DB with no luck. I tried removing some
images but still the file size did not reduce at all.

Any advice appreciated as this student is fast fillling her network
disk quota !

Thanks in advance.

Access does not handle images well. What are the images doing? Are they
used as background for forms or are they stored as data?

As I recall access changes images to Bitmap format when it stores them
making almost all files much larger. If they are used for display, resizing
the original to no larger bit size than will be displayed will help.