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

[ultra2]

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

 

[johnwm]

A quick search on the site gives (amongst others):

thread222-932163
thread222-910875
thread709-474678

Read faq222-2244 to get advice on getting the best answers

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller