[AccessD] 2007 Compact and Repair

It might be doing a decompile/compile cycle.

That usually reduces the size of my databases.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, May 10, 2008 6:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 2007 Compact and Repair

Thanks. I noticed that that is also where "Back Up a Database" lives. Yay!

Anyone have an idea why "Back Up a Database consistently makes smaller
databases than Compact and Repair? My guess is that it creates a new db and
then imports everything into it, but that's just a guess. Identical behavior
in Access 2003, too.

Arthur

On Sat, May 10, 2008 at 5:36 PM, Jeff B <jeff.developer at gmail.com> wrote:

> Click on the circle thing in the upper left hand corner, then go to
Manage.
> Compact and Repair is the top option
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com