Re: Discerpancy in number of records

Alan,

First, check the FAQ at http://www.mvps.org/access/netiquette.htm. Then, if
you still feel compelled to open yourself to complaints because all you post
is spam promoting your own products, please do the the courtesy of not
piggy-backing them onto my responses.

For the information of anyone not already aware:

"Alan" is a spammer.

"Alan" is trying to subvert the newsgroup to be an advertising vehicle.

"Alan" posts no useful answers here.

"Alan" suggests use of tools that bear little, sometimes no, relationship
to the original problem.

Larry Linson
an original approver of comp.datbases.ms-access
when it was created in 1993 and still around

"Alan" <fyz@xxxxxxxxxxxxx> wrote in message
news:ce828f6a-1fcf-46c9-b0aa-e14bf74fb1a8@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 15, 1:17 pm, "Larry Linson" <boun...@xxxxxxxxxxxxx> wrote:
<rfd...@xxxxxxxxxxxxx> wrote in message

news:cnsm241g84nt555ebur7rcrt8oijfkom0v@xxxxxxxxxx

Okay, I've determined this much. A number of years ago, I had this
database
originally in DbaseIII, an old DOS program. Apparently when I got Office
2000, I
converted or imported the DbaseIII data intoAccess. Not sure which.
Sorry
for
the confusion, but I just figured that out last night. However, ever
since
the
first conversion or import, I've usedAccessexclusively to enter my CD's
as I
bought them. I don't know if this info helps or clouds the issue, but
that's
what happened. Thanks agin for the posts and help.

Whatever you think you are doing, the database to which you posted a link
has only one object, a link to an external DBase table... which table, of
course, is not in the download. If you have been "usingAccessto enter the
data", it would seem that you have been opening that linked DBase table in
data*** view, and entering records into the DBase table. It appears,
once
I reset the references to include the MicrosoftAccessDAO 3.6 Library, and
copy in some code, and run it that you have in the root directory of your
C:
drive a folder named DBASEIII and in it, the source table for the linked
table CD_DISKS, which is named DBASEIII.DBF.

There is noAccesstable, so either you uploaded the wrong database for us
to, or you only linked not imported the DBase table.

As I see no Queries in the database, you'd need to tell us in detail how
you
are sorting the table... do you open it in data*** view and select
sorting
from the toolbar?

My guess is that the first step toward correcting the problem you asked
about is to actually import that DBASEIII.DBF into a real, genuineAccess
table. Then you could upload again and someone might be able to assist.
(Provided you give us detail steps of what you are doing to view and sort
the table.)

Easiest way, likely, is to create a new, emptyAccessdatabase. On the menu
File | Get External Data, and _carefully_ follow the prompts to IMPORT it
into anAccesstable. It's possible that you'll find you no longer have the
same problem when you work with theAccesstable.

Larry Linson
Microsoft OfficeAccessMVP

Hi,

If necessary, you can try to recover the mdb file. You may try
Advanced Access Repair at http://www.datanumen.com/aar/ This tool is
rather useful in salvaging damaged Access MDB files.

Alan


.