On Tue, 13 May 2008 17:22:12 -0700 (PDT), lyle fairfield
<lyle.fairfield@[EMAIL PROTECTED]
> wrote:
>On May 13, 7:14 pm, 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 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?
>
>E-mail it to me lyle dot fairfield at gmail dot com and I'll post it
>and post the link here.
Thanks but no need. I realized I could upload it to my own website and it
can be
downloaded from there. The link is:
http://www.folkusa.org/CD_DISKS.mdb
|
