Database size increase abnormaly.

[Peter chin]

Guys,

My B-End database - (A2003) is 57 MB after compact. 110 MB before compact.
After a days, it increase back from 57 to 110 again.

I had create a new mdb and import the data from the existing mdb and compact
it after import, it show 57 MB, but it do give the same result after a day
which it shot up again to 110 MB.

Guys any ideal, where it been going wrong ?

Thanks.

Peter.

 

[Guest]

Hi Peter,

Here is a link for you to start your search of possible causes of DB bloat:

http://tinyurl.com/2dmpw


Tom
__________________________________________

:

Guys,

My B-End database - (A2003) is 57 MB after compact. 110 MB before compact.
After a days, it increase back from 57 to 110 again.

I had create a new mdb and import the data from the existing mdb and compact
it after import, it show 57 MB, but it do give the same result after a day
which it shot up again to 110 MB.

Guys any ideal, where it been going wrong ?

Thanks.

Peter.

 

[Tony Toews]

My B-End database - (A2003) is 57 MB after compact. 110 MB before compact.
After a days, it increase back from 57 to 110 again.

I had create a new mdb and import the data from the existing mdb and compact
it after import, it show 57 MB, but it do give the same result after a day
which it shot up again to 110 MB.

Do you do a lot of record updating? Or importing of data? If so
I'd let it sit for a week and observer the results. An increase of
10% or 20% is certainly normal after a day but yours is definitely on
the high side.

Is everyone at the same Jet SP version?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm