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