Display Table and Field Properties using ADO's OpenSchema Method

Category:

Database

Type:

Applications

Difficulty:

Intermediate

Author:

Anonymous

Version Compatibility: Visual Basic 6

More information:

This applications illustrates: (1) how to use the ADO Schema to obtain a list of tables of a database (2) possible techniques to enable opening several tables on the screen in the same session (using the same form) yet without conflict. (3) how to display various attributes/properties in human readable text, as opposed to VB's original numeric codes.

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.

Download databaseapp.zip