Data Shaping and And Data Object Information Using ADODB and ADOX

Author: Brian Gillham (Featured Developer)
Category: Database
Type: Classes
Difficulty: Intermediate


Version Compatibility:
Visual Basic 5 Visual Basic 6
More information: This class allows you to obtain information about a database using ADOX, Microsoft's new extensions to ADO that allow you to set and read information about database objects such as tables, fields, and indexes. It also includes a function that returns a shaped recordset (a recordset that includes a child recordset as a column) without you having to write the complex SQL syntax for Shaping.

According to Microsoft's documentation, the Access JetOLEDB provider is the only one that fully supports ADOX. However, most of the the functions in the class have been tested with SQL Server 7.0, where they work fine. They should work with other providers (current and future) to the degree that they support the ADOX functionality included in this class.

Reviewing and using this class is an excellent way to familiarize yourself with Shaping and ADOX, which will undoubtedly soon become widely adopted technologies.


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

code/ADOAccess.zip