Database Structure

[jhsurti]

I need some code to print out the complete structure of my database. There are many tables each with many fields. Also many queries. So i need to write a routine which will at least output the structure - table_name, index, field_names, field_data_type, and field_size where applicable. I had seen something of this somewhere on the net in VB but I dont remember where. Professional tools are available but might prove costly.
Thanks

 

[bjackson]

Try using the access built in documenter

Select Tools > analyze > Documenter

Regards
Bjackson

 

[WayneRyan]

jh,

Tools --> Analyze --> Documenter

Wayne

 

[jhsurti]

Thanks a lot.