Getting Access schema for NG posting

[Laphan]

Hi All

I've created my Tables in Access using it's standard Design window, but I
don't seem to be able to export my schema of these tables so that I can post
it to this NG.

Should I really have created the schema using an SQL script/text file and
then executed this on my Access DB? Is this the way that you would do it?

Do you know of a menu (or method) in Access that I can get the necessary
schema out?

Thanks

Laphan

[McKirahan]

"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:eXlpnEQMEHA.1388@TK2MSFTNGP09.phx.gbl...

> Hi All
>
> I've created my Tables in Access using it's standard Design window, but I
> don't seem to be able to export my schema of these tables so that I can

post

> it to this NG.
>
> Should I really have created the schema using an SQL script/text file and
> then executed this on my Access DB? Is this the way that you would do it?
>
> Do you know of a menu (or method) in Access that I can get the necessary
> schema out?
>
> Thanks
>
> Laphan

I use the following to view/print an MS-Access's database schema:

Tools + Analyze + Documenter;
Options = (Include for Fields) Names, Data Types, and Sizes;
Select (a table or tables);
then wait a minute or two ...

I've heard from others that the Analyze feature is not always installed...