For ADO database application: To show (1) How to use ADO schema to obtain a list of tables of a database. (2) How to provide a re-usable single form for any MDB file name, and with another form to display as many tables as there are in that database at the same time. Otherwise, you will have to repeatedly create/refer to an instance of connection and you may need 10 forms if there are 10 tables in a database (see “3”). (3) The possible techniques to enable opening several tables on the screen in the same session, yet without conflict (otherwise if you create 10 instances of the same form, some common event handlers will mix up Table B as Table A, e.g. when calling yet another form. But with appropriate techniques, this conflict is avoided). (4) How to display various properties/attributes/status in descriptive text(pneumonic), rather than the VB’s original numeric codes. Note: MS TreeView itself limits the node count to 32767 only. (For a comparative study of DAO, refer my DBofDAO)
Original Author: Herman Liu
Inputs
See code
Assumptions
See comment lines in source code
Returns
See code
Attachments
| File | Uploaded | Size |
|---|---|---|
| CODE_UPLOAD15746332001.zip | 9/3/2020 3:45:00 PM | 24438 |