Create a VB Class to Process an Access Table using ADO - February 2003 - Tip of the Month

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Create a VB Class to Process an Access Table using ADO - February 2003 - Tip of the Month

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.