Document - Table Structures... ??

[smedvid]

Under Access 97 users had the option to Save the results of Analyze-Documentor. It appears under Access-2000 and XP that this Save As Table option has been removed.

So, is there any means (or tools) to dump a table structure under 2000 or XP? Basically, I want Table Name, Field Name, Type and Size. I know I can write code to loop through Table Defs, but, I really don't want to code.

I even tried to convert from Access 2000 to 97, but I get a cryptic error message - and the convert fails.


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[johnnymac43]

It's a bit messy, but you can export the report from the Documenter to Excel, and then copy the field properties (from a contiguous group of cells for each Access table) to a new Access table.

HTH

John