Re: Discerpancy in number of records

On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1975@[EMAIL PROTECTED]
>
wrote:

>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
>
><rfdjr1@[EMAIL PROTECTED]
> wrote in message 
>news:piuj24p8qb3ors3j2kt1mi9t64uitmoq07@[EMAIL PROTECTED]
>> On 13 May 2008 03:22:36 GMT, "David W. Fenton" 
>> <XXXusenet@[EMAIL PROTECTED]
>
>> wrote:
>>
>>>rfdjr1@[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.
The
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
about not
being able to repair it or anything. When I open it up, the number
difference is
still there. I tried it on both sorts.