[AccessD] Back End Bloat - Revisited

> <<The app can run for several complete processing cycles (each cycle
> involves the collection of data from text files produced by other systems)
> with no weight gain - NONE, and then it will suddenly leap in size by as
> much as 100 MB.  Within a couple of hours, it will have grown from about 
> 150
> MB to well over 500 MB.  Then within 24 hours, it will have grown to a 
> size
> approaching 2 GB, requiring a compact.  The last time I ran through this
> routine, the compacted size was just 8K larger than the size it started 
> out
> at before it started growing.>>
>
>  Are you updating existing records or just appending?  And what version of
> Access/JET is this?

=====I'm curious if the original source files are coming from a different 
source -- since you say "other systems" -- I'm wondering if the source files 
might be your culprit in the form of phantom characters. As a test, you 
might watch to see if the incoming source is always the same. If it is, 
clean the data up in Excel before importing into Access.

Susan H.