[AccessD] Access 2007 Compacting on Opening and Closing - SOLVED

The one database was on a user's machine in another state.
He never noticed the compacting until a file grew over 200MB.
BUT, he have been working with this database solution for months and
recently upgraded his Office install to 2007.  The database file was
also converted to Access 2007.
The default Macro Settings is to "Disable all macros with notification"
so when he clicked the options button to allow the code, he would get
the compacting message in the status bar.
When I told him to change the Macro Settings to "Enable all macros..."
the compacting message on opening did not occur.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Wednesday, May 27, 2009 4:22 PM
To: Access Developers discussion and problem solving
Subject: [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.
################################################################################