[AccessD] Access 2007 Compacting on Opening and Closing

I have a rather complex Access 2007 database that imports multiple
files, manipulates the data, then exports several files in different
formats.  Starting with a file that is about 2MB and then after
importing, manipulating the data, and exporting the file size jumps to
over 240MB.  That's expected.  When it closes it compacts... that also
is expected and planned.

The database is used as an intermediate step manage data that is
exported from a legacy system (sometimes the export is 20 or more files)
to importing into a new system... with one file.  A file with no data is
maintained so that when the need arises it can be copied and the new
exports can be imported into the new system.

 

There is one file that after it grew to 257MB, it started to compact
when opening and closing.  

I've scanned several Access sites and Microsoft but can't find anything.

 

Any ideas why this would occur?

 

Thanks,

 

Jim

 

Jim Hewson 

 


################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################