Access97 Q. maybe easy !!Please!!

[Bongo]

Greetings,

is it possible to create a report in Access from himself?
e.g. I like to get a report of all tables, fields, fieldtypes and fieldproperty.

Is there a example somewhere or can someone point me in the right direction.

Thanks in advance
Manfred

[PilgrimPete]

Don't know about 97, but in 2K and XP there is an analyse wizard:
Tools --> Analyze --> Documenter

If not, you can do a similar thing in code, using TableDefs, FieldDefs etc.

[Bongo]

thanks PilgrimPete,
but I am in the moment on a client computer
with no access to any development env. otherwise I would do
it quickly in VB.

and I can not find any wizards in access97.

Any suggestion?

[goatsucker]

There is a system table called MSysObjects, which is a list of all objects in the database. You can see this an all the other system tables by going to Tools->options->View Tab, and set the "System Objects" checkbox. To get a list of all tables [code]Select Name
FROM MSysObjects
WHERE type =1[code/]
will give you all table names (Including the System tables). You can do similar with other objects (I think for Querues, Type = 5).

Not sure about fileds, but they may turn up in this table. Have a look and see what you get.

[Bongo]

Hi goatsucker,

thanks for the input - did'nt know aqbout this feature, but
it only schows value 1,2,3 where 1 = tables, 2 = somthing called MySysDB and 3 looks like Relationships etc.

Is it not possible to do a select statement like

select field, fieldtype, fieldproperty from <Table> ??