Member Avatar for dinilkarun

hi,

Through VB i would like to delete duplicate rows in MS ACCESS.

Note: There are no PKEY in Database
also the DB allows duplicate records.

Please help

Regards,
DINIL

  • 2 Contributors
  • 1 Reply
  • 43 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for QVeen72

Hi,

When you dont have a Primary Key, Follow this Routine:

Create a Blank TempTable (Same Structure As MainTable)

Insert Into TempTable Select Distinct * From MainTable

Delete All Records From MainTable

ReInsert Records From TempTable To Main Table

Regards
Veena

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.