Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
All records duplicated 1
- Thread starter chudleigh
- Start date
-
1
- #2
chudleigh,
I've been pondering this fir a few days and I end up in the same corner...meaning, you haven't really given us enough to work with to suggest an appropriate course of action.
do you have a primary key? If not, then that's why you're getting duplicate records. The database business rules are weak.
There are two easy ways to delete them:
1. Key the table and ensure that the resulting KEYVIOL.DB table actually contains duplicate data. If not, then re-enter it into the newly keyed table.
2. Run a Check query or a SELECT DISTINCT SQL query against the table; this will retrieve the first record matching every checked (QBE) or selected (SQL) field.
Other alternatives are, of course, possible.
Hope this helps...
-- Lance
I've been pondering this fir a few days and I end up in the same corner...meaning, you haven't really given us enough to work with to suggest an appropriate course of action.
do you have a primary key? If not, then that's why you're getting duplicate records. The database business rules are weak.
There are two easy ways to delete them:
1. Key the table and ensure that the resulting KEYVIOL.DB table actually contains duplicate data. If not, then re-enter it into the newly keyed table.
2. Run a Check query or a SELECT DISTINCT SQL query against the table; this will retrieve the first record matching every checked (QBE) or selected (SQL) field.
Other alternatives are, of course, possible.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Question