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