On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield
<lyle.fairfield@[EMAIL PROTECTED]
> wrote:
>On May 13, 5:55 pm, rfd...@[EMAIL PROTECTED]
wrote:
>> On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@[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
>>
>> ><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.
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.
>
>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?
|
