Recently I published a tip that creates VB 6 code to process an Access
database using DAO. This month I updated the code to use ADO. Unlike the DAO
tip that created a text file whose code was pasted into a class module the
ADO version creates the actual class module - no more cutting a pasting
required. Methods include: LoadAll, LoadUsingGUID, Insert, Update, Delete,
ObjectToObjectCopy, ObjectToObjectDiffer, ObjectToParameters and RSToObject.
The generated code creates properties and SQL statements to process the
table. It also creates the stored procedures.

Link to:

http://www.buygold.net/tips

to view the tip.

Cheers,
Larry Rebich