Database documentation utility

[davesmith202]

I want to have a report that lists the tables and the number of records in several of my databases. And (possibly) a list of Querys, Forms, Reports, Macros and Modules.

Ideally it would create a text file that I could just copy and paste.

Are there any utilities that do this? Or do I have to roll my own?

Thanks,

Dave

 

[The Member]

I think you can look into the MSysObjects, go to tools options, and then unhide the System objects. a list of new table will be added.

MSysObjects store information on the object created. so you have a list of things that is in the DB, tables, queries, form, and modules too. so you can play about with it.

I realise you can make a Query out of that table too which I hope will help..

as for the number of row in a table. I have no idea where will it stored and any info would be cool.

JL

 

[Rich]

Doesn't the built in documenter do it?