DESC in Access

[moriak]

Hi

I am looking for an equivalent for the DESC command in Access.

I need to extract the table definitions: name of each fields (at least).
I know I can print that from the menu in Access, but it's not what I want. (and it does not print the comments section of the fields)

I need to be able to generate some kind of text file cause I need to manipulate the output myself with a Text Editor for documentation purpose.

Is there such a function in Access? Or is there any module that can do that?

Thanks

 

[jeremie_ingram]

What about the documenter function in access? Could that do what you are looking for? Tools - Analyze - Documenter

 

[ghudson]

Does this give you any ideas... Export All Database Objects Into Text Files

 

[moriak]

What about the documenter function in access? Could that do what you are looking for? Tools - Analyze - Documenter

No that's what I want to avoid, but thanks

 

[SMatthews]

Try this. Pat Hartman wrotea function that I believe should help you out. It will creat a table that will list table name, field name and all field name attributes. Let me know if this helps.

http://www.access-programmers.co.uk/forums/showthread.php?t=9790&highlight=Loop+TableDefs+collection

 

[moriak]

Does this give you any ideas... Export All Database Objects Into Text Files

Hi, thanks for the reply.

I tried the function. It dumbed all the data of all my tables in text files. Realy cool script btw, but no descriptive information was included in the txt file. I read the description of the script and from what you wrote in the other post, it is supposed to do so, right? (I'm using access 2000). Maybe I did something wrong.

Also, I found a link that describe the function I would like to simulate in Access:

http://dev.mysql.com/doc/refman/4.1/en/describe.html

Thanks

 

[moriak]

Try this. Pat Hartman wrotea function that I believe should help you out. It will creat a table that will list table name, field name and all field name attributes. Let me know if this helps.

http://www.access-programmers.co.uk/forums/showthread.php?t=9790&highlight=Loop+TableDefs+collection

Hi, yes this looks good.

I tried to run the code. I pasted it in a module and clicked run (play button) and I get and error on:

TempSet1!OrdinalPosition = fldLoop.OrdinalPosition
Method or data meber not found on ".OrdinalPosition".

I included the DAO 3.6 lib since I saw that the script is using the Database object. Maybe I am missing something else.

Thanks

 

[SMatthews]

Did you create a table with the fields listed in the code?