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.
21  1893 
<rf****@optonli ne.netwrote in message
news:kr******** *************** *********@4ax.c om...
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
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localh ost.notwrote:
>
<rf****@optonl ine.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?
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localh ost.notwrote:
>
<rf****@optonl ine.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.
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****@optonli ne.netwrote in message
news:qj******** *************** *********@4ax.c om...
On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localh ost.not>
wrote:
>>
<rf****@opton line.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.
rf****@optonlin e.net wrote in
news:kr******** *************** *********@4ax.c om:
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/
On 13 May 2008 03:22:36 GMT, "David W. Fenton" <XX*******@dfen ton.com.invalid >
wrote:
>rf****@optonli ne.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.
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****@optonli ne.netwrote in message
news:pi******** *************** *********@4ax.c om...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XX*******@dfen ton.com.invalid >
wrote:
>>rf****@optonl ine.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.
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mr*******@btin ternet.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****@optonl ine.netwrote in message
news:pi******* *************** **********@4ax. com...
>On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XX*******@dfe nton.com.invali d>
wrote:
>>>rf****@opton line.net wrote in
news:kr***** *************** ************@4a x.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.
On May 13, 5:55*pm, rfd...@optonlin e.net wrote:
On Tue, 13 May 2008 22:28:45 +0100, "Mark" <mreed1...@btin ternet.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...@optonli ne.netwrote in message
news:pi******** *************** *********@4ax.c om...
On 13 May 2008 03:22:36 GMT, "David W. Fenton"
<XXXuse...@dfen ton.com.invalid >
wrote:
>>rfd...@optonl ine.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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bryan Zash |
last post by:
When querying a bit field, I am encountering a problem with MS SQL
Server returning a larger number of records for a table than the
actual number of records that exist within that table.
For example, my customer table has 1 million unique records, so the
results of the following query are as such:
select count(customer_nbr) from customer = 1,000,000
There is bit field in the customer table that denotes whether a
|
by: Milo Woodward |
last post by:
Does anyone know how to retrieve the number of records an XML file
contains with a vb.net method? I can read through an entire XML file,
import records into SQL Server, etc. However, I don't want to have to
cycle through the entire XML file in order to do this. When I am
importing the XML file, I want to display record X of XX. Any ideas
would be appreciated. Thanks in advance.
|
by: DataFreakFromUtah |
last post by:
Hello!
No question here, just a procedure for the archive.
Search critera:
count records imported count data imported count number of rows
imported
count number of records imported record import count automatically
import
and count records prompt for number of records imported import count
auto-import records
autoimport records count records before and after
|
by: Scott269 |
last post by:
So I've got an old MS Works database I imported into Access. I needed
a primary key so I created a record number field that was just the
record number I manually inserted when I entered it in the database so
I could sort the records by the date at which they were entered.
Well now I've deleted some of those records so its of course causing
gaps in the records. The record number in Access no longer matches my
record number that I...
|
by: King |
last post by:
Hi
I have following MS Acess query
Here is the query
ID Name Prgm ID Client ID Date Start Time End
Time Minutes
C4 Trisha TIP DEK0703 7 /7 /2006 10:00:00 AM 12:00:00 PM
120
| | |
by: Hexman |
last post by:
Hello All,
How do I limit the number of detail records selected in a Master-Detail set using SQL?
I want to select all master records for a date, but only the first 3 records for the details (based on the primary key of the detail record). I've
been trying with "TOP 3", but can't get anywhere. Using Access 2000.
Something like:
SELECT t1.*, TOP 3 t2.*
|
by: itm |
last post by:
I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?
Thanks so much for your help!
|
by: =?Utf-8?B?UHJpeWE=?= |
last post by:
Hi,
I'm faced with a classic problem of how to update a large number of
records from a web page. I;m trying to build an interface that will
display recordset in the order of 3000 rows and allow the user to edit and
update records from that interface. I have cached some static lists in
the page but the main recordset should reflect updated data so it can't
be cached. I also compute some control functions over the whole data.
This will...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
