Exporting database documenter info to table

[Browser]

Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how do to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can not
be opened".
Thanks.

 

[Paul Shapiro]

Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how do
to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can
not
be opened".

I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the code
to output in any format you want. I wrote the code for checking student db
projects when I was teaching a db course, so the output includes warnings on
what I considered common issues. The code is too long to post here, so email
me privately if you want the code, making the obvious correction to my email
address.

 

[audie collins]

I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the
code to output in any format you want. I wrote the code for checking
student db projects when I was teaching a db course, so the output
includes warnings on what I considered common issues. The code is too long
to post here, so email me privately if you want the code, making the
obvious correction to my email address.

 

[Duane Hookom]

I believe you can link to the documenter data from the file ACWZUSR12.ACCDU
in the folder C:\Users\_your user name
here_\AppData\Roaming\Microsoft\Access\

 

[Sakaguti]