On May 13, 11:53=A0pm, lyle fairfield <lyle.fairfi...@[EMAIL PROTECTED]
> wrote:
> On May 13, 9:52=A0pm, rfd...@[EMAIL PROTECTED]
wrote:
>
>
>
> > On Tue, 13 May 2008 17:22:12 -0700 (PDT), lyle fairfield
>
> > <lyle.fairfi...@[EMAIL PROTECTED]
> wrote:
> > >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]
> 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
sh=
ows
> > >> >> >>>> 393 records. Any idea why this would be?
>
> > >> >> >>>This is a classic symptom of a corrupted index. Make a backup
c=
opy
> > >> >> >>>of your data MDB and compact it. If the index was corrupted,
th=
at
> > >> >> >>>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
W=
inzip?
> > >> >> >> Also, if
> > >> >> >> this index is corrupted, how do I recreate it? I am a very
casu=
al user of
> > >> >> >> Access
> > >> >> >> and only have a few simple databases for some collections I
hav=
e 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
happ=
ened. 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
mess=
ages 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
f=
or
> > >> >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
i=
t can be
> > downloaded from there. The link is:
>
> >http://www.folkusa.org/CD_DISKS.mdb
>
> I usually know what to say, but not this time.
I thought of something:
Perhaps, those who were about to expunge Access from their hard drives
and remove it from their application development repertoire because of
the anomaly re****ted in the original post should examine
http://www.folkusa.org/CD_DISKS.mdb
before doing so.
|
