Exporting database documenter info to table

  • Thread starter Thread starter Browser
  • Start date Start date
B

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.
 
Browser said:
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".
Click to expand...

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.
 
Paul Shapiro said:
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.
Click to expand...
 
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\
 
Back
Top