By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Discerpancy in number of records

P: n/a
I'm using Access 2000. I have a raher simple database of my CD collection, with
just three fields, Artist, Album Title and Type of Music. While going to update
it today with a couple new CD's, I noticed that 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? And I know of at least two titles that don't show
up when I look for them under the Artist sort. There's obviously a few more
missing. Thanks.

Jun 27 '08 #1
Share this Question
Share on Google+
21 Replies


P: n/a

<rf****@optonline.netwrote in message
news:kr********************************@4ax.com...
I'm using Access 2000. I have a raher simple database of my CD collection,
with
just three fields, Artist, Album Title and Type of Music. While going to
update
it today with a couple new CD's, I noticed that 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? And I know of at least two titles that don't
show
up when I look for them under the Artist sort. There's obviously a few
more
missing. Thanks.
Access 2000 is "out of support", but the Service Packs and other updates are
still available -- my first step would be to look at "Help | About Microsoft
Access 2000" and make certain that it is at the SP3 level; then go to the
Microsoft site for Office update and see if there are later updates.

If you are up-to-date, or if you still experience this after bringing your
Access up to date, go into Query Builder, on the leftmost part of the
toolbar, click the dropdown, choose SQL view, copy the SQL for both querys,
paste it into a response to this thread, and maybe someone will have a good
suggestion.

Larry Linson
Jun 27 '08 #2

P: n/a
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localhost.notwrote:
>
<rf****@optonline.netwrote in message
news:kr********************************@4ax.com.. .
>I'm using Access 2000. I have a raher simple database of my CD collection,
with
just three fields, Artist, Album Title and Type of Music. While going to
update
it today with a couple new CD's, I noticed that 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? And I know of at least two titles that don't
show
up when I look for them under the Artist sort. There's obviously a few
more
missing. Thanks.

Access 2000 is "out of support", but the Service Packs and other updates are
still available -- my first step would be to look at "Help | About Microsoft
Access 2000" and make certain that it is at the SP3 level; then go to the
Microsoft site for Office update and see if there are later updates.

If you are up-to-date, or if you still experience this after bringing your
Access up to date, go into Query Builder, on the leftmost part of the
toolbar, click the dropdown, choose SQL view, copy the SQL for both querys,
paste it into a response to this thread, and maybe someone will have a good
suggestion.

Larry Linson
Thanks. I checked "Help | About and see nothing at all mentioning SP3 or
anything else. Just the version number, copyright info and Product ID number. Am
I looking in the right spot?

Jun 27 '08 #3

P: n/a
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localhost.notwrote:
>
<rf****@optonline.netwrote in message
news:kr********************************@4ax.com.. .
>I'm using Access 2000. I have a raher simple database of my CD collection,
with
just three fields, Artist, Album Title and Type of Music. While going to
update
it today with a couple new CD's, I noticed that 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? And I know of at least two titles that don't
show
up when I look for them under the Artist sort. There's obviously a few
more
missing. Thanks.

Access 2000 is "out of support", but the Service Packs and other updates are
still available -- my first step would be to look at "Help | About Microsoft
Access 2000" and make certain that it is at the SP3 level; then go to the
Microsoft site for Office update and see if there are later updates.

If you are up-to-date, or if you still experience this after bringing your
Access up to date, go into Query Builder, on the leftmost part of the
toolbar, click the dropdown, choose SQL view, copy the SQL for both querys,
paste it into a response to this thread, and maybe someone will have a good
suggestion.

Larry Linson
Okay, I went to Microsoft's site and first downloaded SP1a as I apparently had
no SP's installed. I installed that then installed SP3 so all is up to date (the
SP version shows up now in Help | About), but the problem with the number of
records still exists. Now I can't find Query Builder anywhere in any drop down
menus or on the tool bar. I looked it up in Help and it tells me to open a
document in Design View. I tried that and get a warning that I can't do that
because the security setting in my browser is set too high and to lower it or
see my system administrator. I AM the administrator. This is my home computer.
What browser are they talking about? I only know about web browsers i.e.
Internet Explorer. What would this have to do with Access? I'm totally confused.
Bottom line is I just can't figure out why, with one sort I get one number of
records and with another sort, I get a different number.

Jun 27 '08 #4

P: n/a
With the database window open, click the Queries tab, highlight the Query,
and click the Design button -- that screen is Query Builder. In (design
view in) Query Builder, there should be a toolbar just above the design
grid, and by default, the leftmost button will allow you to go from Design
View (a "tool" icon) to Query View (a datasheet icon) to SQL View (the
letters SQL). Some later versions (Access 2002 and 2003) also have Pivot
Chart and Pivot Table view in the dropdown, but I can't remember if Access
2000 has those or not -- but they are not pertinent to our discussion.

In SQL View, you can highlight and copy (Ctrl-C) the SQL and paste it into a
post... if you do that for both the Query that gives you all the records and
the Query that gives you fewer, then someone can take a look -- it may not
be me, as I don't have Access 2000 installed on an active PC.

I don't know what you are experiencing about "browser" because there's no
web browser involved with a normal Access MDB.
<rf****@optonline.netwrote in message
news:qj********************************@4ax.com...
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localhost.not>
wrote:
>>
<rf****@optonline.netwrote in message
news:kr********************************@4ax.com. ..
>>I'm using Access 2000. I have a raher simple database of my CD
collection,
with
just three fields, Artist, Album Title and Type of Music. While going to
update
it today with a couple new CD's, I noticed that 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? And I know of at least two titles that
don't
show
up when I look for them under the Artist sort. There's obviously a few
more
missing. Thanks.

Access 2000 is "out of support", but the Service Packs and other updates
are
still available -- my first step would be to look at "Help | About
Microsoft
Access 2000" and make certain that it is at the SP3 level; then go to the
Microsoft site for Office update and see if there are later updates.

If you are up-to-date, or if you still experience this after bringing your
Access up to date, go into Query Builder, on the leftmost part of the
toolbar, click the dropdown, choose SQL view, copy the SQL for both
querys,
paste it into a response to this thread, and maybe someone will have a
good
suggestion.

Larry Linson
Okay, I went to Microsoft's site and first downloaded SP1a as I apparently
had
no SP's installed. I installed that then installed SP3 so all is up to
date (the
SP version shows up now in Help | About), but the problem with the number
of
records still exists. Now I can't find Query Builder anywhere in any drop
down
menus or on the tool bar. I looked it up in Help and it tells me to open a
document in Design View. I tried that and get a warning that I can't do
that
because the security setting in my browser is set too high and to lower it
or
see my system administrator. I AM the administrator. This is my home
computer.
What browser are they talking about? I only know about web browsers i.e.
Internet Explorer. What would this have to do with Access? I'm totally
confused.
Bottom line is I just can't figure out why, with one sort I get one number
of
records and with another sort, I get a different number.

Jun 27 '08 #5

P: n/a
rf****@optonline.net wrote in
news:kr********************************@4ax.com:
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 reported to you and you'll have to recreate it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 27 '08 #6

P: n/a
On 13 May 2008 03:22:36 GMT, "David W. Fenton" <XX*******@dfenton.com.invalid>
wrote:
>rf****@optonline.net wrote in
news:kr********************************@4ax.com :
>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 reported 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.

Jun 27 '08 #7

P: n/a
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

<rf****@optonline.netwrote in message
news:pi********************************@4ax.com...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XX*******@dfenton.com.invalid>
wrote:
>>rf****@optonline.net wrote in
news:kr********************************@4ax.co m:
>>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 reported 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.

Jun 27 '08 #8

P: n/a
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mr*******@btinternet.comwrote:
>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

<rf****@optonline.netwrote in message
news:pi********************************@4ax.com.. .
>On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XX*******@dfenton.com.invalid>
wrote:
>>>rf****@optonline.net wrote in
news:kr********************************@4ax.com :

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 reported 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.

Jun 27 '08 #9

P: n/a
On May 13, 5:55*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
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...@optonline.netwrote in message
news:pi********************************@4ax.com...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfenton.com.invalid>
wrote:
>>rfd...@optonline.net wrote in
news:kr********************************@4ax.co m:
>>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 reported 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?
Jun 27 '08 #10

P: n/a
On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield
<ly************@gmail.comwrote:
>On May 13, 5:55*pm, rfd...@optonline.net wrote:
>On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
>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...@optonline.netwrote in message
news:pi********************************@4ax.com.. .
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfenton.com.invalid>
wrote:
>>>rfd...@optonline.net wrote in
news:kr********************************@4ax.com :
>>>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 reported 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?

Jun 27 '08 #11

P: n/a
On May 13, 7:14*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield

<lyle.fairfi...@gmail.comwrote:
On May 13, 5:55*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
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...@optonline.netwrote in message
news:pi********************************@4ax.com...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfenton.com.invalid>
wrote:
>>rfd...@optonline.net wrote in
news:kr********************************@4ax.co m:
>>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 reported 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 andI
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.
Jun 27 '08 #12

P: n/a
On Tue, 13 May 2008 17:22:12 -0700 (PDT), lyle fairfield
<ly************@gmail.comwrote:
>On May 13, 7:14*pm, rfd...@optonline.net wrote:
>On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield

<lyle.fairfi...@gmail.comwrote:
>On May 13, 5:55*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
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...@optonline.netwrote in message
news:pi********************************@4ax.com.. .
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfenton.com.invalid>
wrote:
>>>rfd...@optonline.net wrote in
news:kr********************************@4ax.com :
>>>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 reported 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

Jun 27 '08 #13

P: n/a
On May 13, 9:52*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 17:22:12 -0700 (PDT), lyle fairfield
>
<lyle.fairfi...@gmail.comwrote:
On May 13, 7:14*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield
<lyle.fairfi...@gmail.comwrote:
On May 13, 5:55*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
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...@optonline.netwrote in message
news:pi********************************@4ax.com...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfenton.com.invalid>
wrote:
>>rfd...@optonline.net wrote in
news:kr********************************@4ax.co m:
>>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 reported 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 casualuser 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
I usually know what to say, but not this time.

Jun 27 '08 #14

P: n/a
On May 13, 11:53*pm, lyle fairfield <lyle.fairfi...@gmail.comwrote:
On May 13, 9:52*pm, rfd...@optonline.net wrote:
On Tue, 13 May 2008 17:22:12 -0700 (PDT), lyle fairfield
<lyle.fairfi...@gmail.comwrote:
>On May 13, 7:14*pm, rfd...@optonline.net wrote:
>On Tue, 13 May 2008 15:04:42 -0700 (PDT), lyle fairfield
><lyle.fairfi...@gmail.comwrote:
>On May 13, 5:55*pm, rfd...@optonline.net wrote:
>On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btinternet.comwrote:
>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...@optonline.netwrote in message
>news:pi********************************@4ax.com.. .
>On 13 May 2008 03:22:36 GMT, "David W. Fenton"
><XXXuse...@dfenton.com.invalid>
>wrote:
>>>rfd...@optonline.net wrote in
>>>news:kr********************************@4ax.com :
>>>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 reported 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 databaseclosed 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 numberdifference 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

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 reported in the original post should examine
http://www.folkusa.org/CD_DISKS.mdb before doing so.
Jun 27 '08 #15

P: n/a
To the OP:

It appears to me that we would need the file CD_Disks.DBF also don't you think ??

Arno R

Jun 27 '08 #16

P: n/a
"Arno R" <ar****************@planet.nlwrote
To the OP:
It appears to me that we would need the file CD_Disks.DBF also don't you
think ??
Arno R
It appears to me that we'd not necessarily be closer to answering the
question if we had the linked dBase table, because there are no other
objects in the database. It's really difficult to debug Queries that we can
not examine.

Larry


Jun 27 '08 #17

P: n/a

"Larry Linson" <bo*****@localhost.notschreef in bericht news:1KJWj.2600$0h.2278@trnddc02...
"Arno R" <ar****************@planet.nlwrote
To the OP:
It appears to me that we would need the file CD_Disks.DBF also don't you
think ??
Arno R
It appears to me that we'd not necessarily be closer to answering the
question if we had the linked dBase table, because there are no other
objects in the database. It's really difficult to debug Queries that we can
not examine.

Larry

Did the OP claim that he used a query ??
My guess is that he is sorting the table directly.
Maybe he will clarify..., maybe not ...
Arno R
Jun 27 '08 #18

P: n/a
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 into Access. 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 used Access exclusively 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.

Jun 27 '08 #19

P: n/a

<rf****@optonline.netwrote in message
news:cn********************************@4ax.com...
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 into Access. 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 used Access exclusively 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 "using Access to enter the
data", it would seem that you have been opening that linked DBase table in
datasheet view, and entering records into the DBase table. It appears, once
I reset the references to include the Microsoft Access DAO 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 no Access table, 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 datasheet 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, genuine Access
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, empty Access database. On the menu
File | Get External Data, and _carefully_ follow the prompts to IMPORT it
into an Access table. It's possible that you'll find you no longer have the
same problem when you work with the Access table.

Larry Linson
Microsoft Office Access MVP
Jun 27 '08 #20

P: n/a
On May 15, 1:17*pm, "Larry Linson" <boun...@localhost.notwrote:
<rfd...@optonline.netwrote in message

news:cn********************************@4ax.com...
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
datasheet 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 datasheet 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

Jun 27 '08 #21

P: n/a
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" <fy*@datanumen.netwrote in message
news:ce**********************************@f24g2000 prh.googlegroups.com...
On May 15, 1:17 pm, "Larry Linson" <boun...@localhost.notwrote:
<rfd...@optonline.netwrote in message

news:cn********************************@4ax.com...
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
datasheet 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 datasheet 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
Jun 27 '08 #22

This discussion thread is closed

Replies have been disabled for this discussion.