Hi
I would not run a Compact unless I was told that it was needed,
which seems to be your case if Check/Repair asked you to do it. In that
case, the report that Check/Repair produces might give an indication as
to why. Your run times seem to be slow, but it would depend on the size
of the file and your PC.
Just for a test I have duplicated my live database, currently 24676
KB for 12000 people, and then compressed it. That only took a minute or
so and reduced it to 23304 KB so it only got a 5% reduction.
Regards
Chris
------ Original Message ------
From: "Ginny Vocelli" <[email protected]>
To: "Legacy User Group" <[email protected]>
Sent: 10/10/2019 02:28:43
Subject: Re: [LegacyUG] Running compact family file
Thanks for your advice, Chris. I am such a novice at the ends and outs
of Legacy, I panic when something weird happens. I’ll stay away from
Compact Family Records from now on.
Ginny
From: LegacyUserGroup <[email protected]> On
Behalf Of Chris Hill
Sent: Wednesday, October 9, 2019 5:38 PM
To: Legacy User Group <[email protected]>
Subject: Re: [LegacyUG] Running compact family file
Hi
That is good to hear. The Compact, ignore my earlier email, should not
remove any information. All that it does is to compress the various
tables to recover space that had been used by deleted entries.
Basically, Access never overwrites space that had been used by deleted
records. It always just adds new data at the end.
I would not normally expect to use Compress unless I had been deleting
a lot of records.
Regards
Chris
From my Motorola G6+
On Wed, 9 Oct 2019, 22:05 Ginny Vocelli, <[email protected]> wrote:
Whew! The Compact Family File is done! How changed are my files? Is
there a report I can run that will tell me what’s different? Thanks.
Ginny Vocelli
From: LegacyUserGroup <[email protected]> On
Behalf Of Virginia Vocelli
Sent: Wednesday, October 9, 2019 4:45 PM
To:[email protected]
Subject: [LegacyUG] Running compact family file
I set this in motion after a Check and repair told me to. There was an
error (the number of which I cannot remember). The little blue circle
has been spinning for nearly 30 minutes. A drop down box, half of
which I can’t read, tells me this can be time consuming, and that
terminating can be .....what? That part is off the screen.
How long will this take? At the very top left corner Legacy (not
responding.)
Thanks for any advice.
Ginny Vocelli
Sent from Xfinity Connect App
--
LegacyUserGroup mailing list
[email protected]
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/[email protected]/
--
LegacyUserGroup mailing list
[email protected]
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/[email protected]/
