file is inexplicably very big

[NetworkTrade]

have inherited an Access2003 file that is just way too big for what is in it.

has only several tables, a couple forms, a couple queries, a couple
reports but is still 25M after compact

the form had a bitmap background and I eliminated that to white and it still
is this big....no pic/image files in any form or report

the 4 of the 6 tables have look up info that is always there.... and 2
tables have user specific info. I noticed that when I entered test data
into these 2 tables that the file size ballooned up to 280M....before
compact... then compacted back down to 25M

it seems to me this file should not barely even be 2M - is there a way to
see the size of objects?.... any thoughts?

 

[Tom van Stiphout]

On Tue, 11 Dec 2007 09:22:04 -0800, NetworkTrade

Don't fret about it. It's virtually impossible today to buy a hard
drive that's less than 1000 times the size of your db, and you can buy
a hard drive that's 20,000 times that size for less than USD100.

If you must, export all objects to text, and then back into a new db,
using the undocumented SaveAsText method. Google for it.

-Tom.