RE: Automatically Delete Duplicated Data in Table
From: faxylady (faxylady_at_discussions.microsoft.com)
Date: 09/29/04
- Next message: John Vinson: "Re: Complex date query"
- Previous message: Duane Hookom: "Re: Update table from Result of Query"
- In reply to: faxylady: "Automatically Delete Duplicated Data in Table"
- Next in thread: John Vinson: "Re: Automatically Delete Duplicated Data in Table"
- Reply: John Vinson: "Re: Automatically Delete Duplicated Data in Table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Sep 2004 21:07:03 -0700
Well, I proceeded to retry the instructions from the help files with your
advice in mind. Believe it or not, step 8 proceded OK. It allowed me to
save and close the table without any error messages. Previously, I performed
these operations exactly as listed in the help file and received the troubles
above. Recently, I downloaded and installed the Office Updates. I am
noticing some changes in some things. Som things are being corrected. Could
this be one of them? The second half of the help file went OK also and a new
table was created minus all the duplicates. The table with the duplicates
had been created as a result of previous efforts at following the help file
instructions and produced over 28,000 files from an original file of only
790. Please comment. Thanks.
"faxylady" wrote:
> A project that I am working on requires deletion of duplicated data from a
> table. The table consists of only 1 field named Email Addresses. My plans
> are to use the email addresses for sending email. I have used the text data
> type instead of the hyperlink data type because I wish to perform sorting
> operations alphabetically on them periodically as I continue to enter the
> email addresses. So far, I have collected over 800 email addresses from
> various sources. The hyperlink data type inhibited me from using the sort
> feature.
>
> While collecting the data from various sources, many duplicates are
> produced. Therefore, I turned to the help files and located the topic,
> Automatically Delete Duplicate Records from a Table. Every effort has been
> made to follow the instructions meticulously.
>
> Steps 1 –5 are fairly simple, creating a new table by copying and pasting in
> the Database window.. Step 6 states to “Open the new table in Design view,
> and select the field(s) that contained duplicates in the table you copied.”
> No problem here.
>
> Step 7, which states, “Click Primary Key on the toolbar to create a primary
> key based on the selected fields,” proceeds okay.
>
> The difficulty begins with Step 8, which says to “Save and close the table.”
> When “Yes” is clicked, an error message appears stating, “The changes you
> requested to the table were not successful because they would create
> duplicate values in the Index, Primary Key, or relationships. Change the
> data in the field or fields that contain duplicate data, remove the Index, or
> redefine the index to permit duplicate entries and try again.”
>
> The second part of this help file is To append only unique records to the
> new table.
>
> Step 1, Create a new query based on the Original table containing duplicates.
>
> Step 2, In query Design view, click the Query Type on the toolbar, and then
> click Append Query.
>
> Step 3, In the Append dialog box, click the name of the new table from the
> Table Name list, and then click OK.
>
> Step 4, Include all the fields from the original table by dragging the
> asterisk (*) to the query design grid.
>
> Step 5, Click Run on the toolbar.
>
> Step 6, Click Yes when you receive the message that you’re about to append
> rows.
>
> Trouble begins here with Step 7, Click Yes when you receive the message that
> Microsoft Access can’t append all the records in the append query. This
> transfers only unique records to your new table and discards the duplicates.
> This step does not appear. No error message appears.
>
> Steps 8 and 9 to see the results cannot be performed.
>
> The Office 2000 version of Access is being used on a Pentium III, 500 Mg
> machine with a 120gg hard drive. Windows 98 is the operating system.
>
> Please notice the problem at step 8.
>
> Please help me to delete the duplicated records from my table.
>
> Thank you.
>
- Next message: John Vinson: "Re: Complex date query"
- Previous message: Duane Hookom: "Re: Update table from Result of Query"
- In reply to: faxylady: "Automatically Delete Duplicated Data in Table"
- Next in thread: John Vinson: "Re: Automatically Delete Duplicated Data in Table"
- Reply: John Vinson: "Re: Automatically Delete Duplicated Data in Table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
