Dupe Handling in SQL via VB

We maintain a database of student training records, and frequently merge into it records from different sources. We need an extensible VB module that can be adapted to various uses. The code needs to be able to detect duplicate records (where student information is the same, but training information is different) and add/merge/replace as appropriate. The project exists as a Microsoft Access 2000 database. We can provide a stripped-down copy with sample tables and queries to work with. This code should serve as an engine to mediate the merging of properly formatted tables. A sample problem may be that a Student has four rows of training dates in the TrainingUnits table; we then import records which contain a matching Student record, and seven rows in the TrainingUnits table, only two of which match what is in the original tables. The result should be a single record for that student in the Student table, and nine associated records in the TrainingUnits table. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) As a compiled, runnable module within the provided sample database, whose code can then be moved into our production system. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Database runs in Microsoft Access 2000 on Windows XP workstations.