>>>>Anyone know of any documentation tools (free or otherwise) for MS Access? It would be nice to dump the structure in a similar format that VFP uses. tia... Steve
>>>
>>>The Database Documentor in Access prints out all the table and field definitions, relationships and indexes. And there is a free add on for Access 97 that will allow you to print the relationships window directly from Access. What more could you ask for?
>>
>>I found the Print Relationship tool just after posting the message. But, I would like a little more control over the output. Given, I can export to MS Word and manually format the output, but that is too much trouble. I want to just get a dump of the structure in a similar format that is available through xBase/FoxPro. Field Name, Length, Type & Description are sufficient. The other information, while useful, is not necessary for my purposes. +:
>
>I'm not familiar with VFP, so can't say if this is close to what you want, but the following code ought to give you what you need, and let you do the formatting...
>
>dim db as database
>dim i as integer, j as integer
>
>set db = currentdb
>
>for i = 0 to db.tabledefs.count-1
> for j = 0 to db.tabledef(i).fields.count - 1
> debug.print db.tabledefs(i).fields(j).name, db.tabledefs(i).fields(j).type, db.tabledefs(i).fields(j).size
> next j
>next i
>
>if you run this output into a table, you could use that as the recordsource for an Access report, where you could format to your hearts content... hope this helps
>
>Stan B.
>Newport News Shipbuilding

Thanks! I'll give it a try... :-)