Get MDB tables and fields

hi all
with VB6.0 is it possible to get all the tables that are in a particular mdb file
then also i need to know how to get the fields,datatypes and size allocated through vb
please help me out
thanks in advance
siva

Comments

  • : hi all
    : with VB6.0 is it possible to get all the tables that are in a particular mdb file
    : then also i need to know how to get the fields,datatypes and size allocated through vb
    : please help me out
    : thanks in advance
    : siva
    :

    If you add a reference to DAO you should be able to loop through the tabledefs to get each table, and in each table you should be able to loop through the fields to get each field. Each field will have the properties that you are looking for.

    There might be a better way (this is the first time I've advocated using DAO since I abandoned it 3 or 4 yrs ago) but this is quick and easy.
  • thanks yar
    i have got it working thro ADO itself with some catalog and other stuffs
    thanks for giving me a hint that it is also possible to do it with DAO
    thanks once again
    regards
    siva
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories