how to obtain db structure info from an Access db in run-time?

I use dataenvironment and adodb commands to communicate with and Access database from VB6.

I need to get db structure information (such as tables count their names, their fields count and names) in run-time.

so how can I write an sql statement to obtain that? or any other solution for this problem?

plz help

ultra2,

Take a look in my signature for Multi Database Connection that project will give you all the help on doing just that.