If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exporting database documenter info to table
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. |
#2
|
|||
|
|||
Exporting database documenter info to table
"Browser" wrote in message
... 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. |
#3
|
|||
|
|||
Exporting database documenter info to table
"Paul Shapiro" wrote in message ... "Browser" wrote in message ... 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. |
#4
|
|||
|
|||
Exporting database documenter info to table
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\ -- Duane Hookom MS Access MVP "audie collins" wrote in message ... "Paul Shapiro" wrote in message ... "Browser" wrote in message ... 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. |
#5
|
|||
|
|||
Exporting database documenter info to table
"audie collins" wrote in message ... "Paul Shapiro" wrote in message ... "Browser" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|