On May 13, 5:55=A0pm, rfd...@[EMAIL PROTECTED]
wrote:
> On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@[EMAIL PROTECTED]
>
wrot=
e:
> >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
user =
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.
Th=
e
> database was open, I used the compact/repair feature. The database
closed =
back
> to the box I get where I click on it initially to open it. No messages
abo=
ut not
> being able to repair it or anything. When I open it up, the number
differe=
nce 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?
|
