ADO Tips & Tricks 1) Connection Object a) Opening the Database b) Executing Commands c) Executing Queries d) Closing the Database 2) Recordset Object a) The Fields Collection b) Editing Records 3) Tools a) One Column Queries b) ComboBox Example c) One Row Queries d) Multi-Column Queries e) Getting Field Names f) ComboBox Example, 2 4) A Useful Example a) The SELECT Clause b) The WHERE Clause c) The Query Download Example Programs

Tools This is a collection of tools I have found useful for dealing with databases. Database code is likely to change in future versions of Visual Basic so I keep all database code in a separate module. Returning data to the main program may not always be most efficient. For example, if the program must examine and modify every record in a table, it will be faster to process the records using the Recordset directly.