On May 13, 7:14=A0pm, rfd...@[EMAIL PROTECTED]
wrote:
> On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield
>
>
>
> <lyle.fairfi...@[EMAIL PROTECTED]
> wrote:
> >On May 13, 5:55=A0pm, rfd...@[EMAIL PROTECTED]
wrote:
> >> On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@[EMAIL PROTECTED]
>
w=
rote:
> >> >By "Compact", he means a built in functionality of Access.
>
> >> >From the Menu
>
> >> >Tools
>
> >> >Database Utilities
>
> >> >Compact and Repair database
>
> >> >The compact and repair will try to repair any corrupt indices.
>
> >> >Regards,
>
> >> >Mark
>
> >> ><rfd...@[EMAIL PROTECTED]
> wrote in message
> >> >news:piuj24p8qb3ors3j2kt1mi9t64uitmoq07@[EMAIL PROTECTED]
> >> >> On 13 May 2008 03:22:36 GMT, "David W. Fenton"
> >> >> <XXXuse...@[EMAIL PROTECTED]
>
> >> >> wrote:
>
> >> >>>rfd...@[EMAIL PROTECTED]
wrote in
> >> >>>news:krah24lbrfi0mo2dj65agmg0s334eps6pm@[EMAIL PROTECTED]
>
> >> >>>> if I sort alphabetically by
> >> >>>> Artist it have 387 records but if I sort by Album Title it shows
> >> >>>> 393 records. Any idea why this would be?
>
> >> >>>This is a classic symptom of a corrupted index. Make a backup copy
> >> >>>of your data MDB and compact it. If the index was corrupted, that
> >> >>>will be re****ted to you and you'll have to recreate it.
>
> >> >> Thanks. By compact it, do you mean zip it with something like
Winzip=
?
> >> >> Also, if
> >> >> this index is corrupted, how do I recreate it? I am a very casual
us=
er of
> >> >> Access
> >> >> and only have a few simple databases for some collections I have
and=
I
> >> >> don't
> >> >> know the ins and outs of the program. Thanks again.
>
> >> Okay, thanks. I just tried this. Doesn't appear that anything
happened.=
The
> >> database was open, I used the compact/repair feature. The database
clos=
ed back
> >> to the box I get where I click on it initially to open it. No
messages =
about not
> >> being able to repair it or anything. When I open it up, the number
diff=
erence is
> >> still there. I tried it on both sorts.
>
> >I guess the db isn't huge? Why not zip it up and post it somewhere for
> >downloading so that we can see this miracle for ourselves?
>
> The .mdb file is 100Kb. Where should I post it?
E-mail it to me lyle dot fairfield at gmail dot com and I'll post it
and post the link here.
|
