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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete duplicate data in Access

Status
Not open for further replies.
sergiob

sergiob

Programmer
Apr 20, 2002
1
CA
Hello,

how can I delete duplicate data in an Access database and all the data that are related (or not) in other tables. The user will choose wich client he wants to keep in his database and then delete all other occurences in different tables. Solutions with VBA and Access will be appreciated.

Thanks!

Note: I did not look yet at the database so I don't know if all the tables are well designed, nor do I know about the integrity of the db.
 
Status
Not open for further replies.

Similar threads

DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
352
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top