Hi All

I have been passed an Access 2000 database that just contains masses of related tables. Is there a way of determining its schema ultimately to acquire the following in a simple at a glance report:

Table name, Data type, field (column) default value etc..

Many thanks

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

Sure, just go to Tools -> Analyze -> Documenter

Check the tables you want to analyze then click the options button.

I typically turn everything off, except for Name, Datatypes and Sizes in the Fields sections.

HTH

Mike

Mike
EchoVue.com

Billiant Mike, thank you very much.

Rit