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
|
|||
|
|||
Documenter Problems!?
This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Thanks in advance. Rick |
#2
|
|||
|
|||
"Rick" wrote in message:
... This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Humm, that's odd. I did some researching on Access 2003, Documentor, and the error message you mentioned, but did not find anything. I did find something concerning Access 2000 so perhaps this article will help in your situation. ACC2000: Error Message When Running Access Wizards: http://support.microsoft.com/default...b;en-us;303769 Try that and see if that gets the Documentor working. If you are interested in doing some documentation on your database without using the Documentor here are some other possibilities for you. 1. I have created a few add-ins that do some specific database documentation. My "Doug Steele Object Documentor" will create a nice report of all your database objects for easy reference. The report will list all the objects by category in alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in your database that you can open again any time you wish! There is one version for Access 97 and another version that works for 2000, 2002, and 2003. You can find the free Add-In on MVP Doug Steele's site he http://www.accessmvp.com/djste*ele/Documentor.html I also created an Access Add-In called the "John Viescas Table Documentor" that documents the table structures. It is even easier to use than the built-in Access Documentor and creates a slick report that will list each table (including linked ones) and their field properties in an easy-to-read format. I recently finished Version 2.0 of the add-in. This version even works on MDE files. This add-in has not been posted yet to a web site so if you would like a copy please let me know. I have another add-in called the "Albert Kallal Database Statistics" that will make a one-page report that lists the total number of lines of code in Modules, Forms, and Reports (a sub total for each and a grand total) as well as a count of each other type of database object (a sub total for each category and a grand total). This add-in has not been posted yet to a web site as well so if you would like a copy please let me know. I have another add-in that will, among other things, document the User and Group permissions in a secured database. You can find that add-in on MVP Sandra Daigle's site here (at the top): http://www.daiglenet.com/msaccess.htm 2. David Hare-Scott has also written a simple table documentor. You can download it he http://www.rogersaccesslibrary*.com/...e-S*cott,David 3. Armen Stein has something here as well: http://www.jstreettech.com/cartgenie...rDownloads.asp (Look for Data Dictionary Report Utility) 4. You can buy a commercial product like this one that will produce a wealth of information: http://www.fmsinc.com/Products*/analyzer/index.html Hope that gives you some ideas. Let us know how it goes. -- Jeff Conrad Access Junkie Bend, Oregon |
#3
|
|||
|
|||
Jeff, That's quite a wealth of information. I almost need a documentor just to document all the places where I can find all the various Access documentors. :-) Immanuel Sibero "Jeff Conrad" wrote in message ... "Rick" wrote in message: ... This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Humm, that's odd. I did some researching on Access 2003, Documentor, and the error message you mentioned, but did not find anything. I did find something concerning Access 2000 so perhaps this article will help in your situation. ACC2000: Error Message When Running Access Wizards: http://support.microsoft.com/default...b;en-us;303769 Try that and see if that gets the Documentor working. If you are interested in doing some documentation on your database without using the Documentor here are some other possibilities for you. 1. I have created a few add-ins that do some specific database documentation. My "Doug Steele Object Documentor" will create a nice report of all your database objects for easy reference. The report will list all the objects by category in alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in your database that you can open again any time you wish! There is one version for Access 97 and another version that works for 2000, 2002, and 2003. You can find the free Add-In on MVP Doug Steele's site he http://www.accessmvp.com/djste*ele/Documentor.html I also created an Access Add-In called the "John Viescas Table Documentor" that documents the table structures. It is even easier to use than the built-in Access Documentor and creates a slick report that will list each table (including linked ones) and their field properties in an easy-to-read format. I recently finished Version 2.0 of the add-in. This version even works on MDE files. This add-in has not been posted yet to a web site so if you would like a copy please let me know. I have another add-in called the "Albert Kallal Database Statistics" that will make a one-page report that lists the total number of lines of code in Modules, Forms, and Reports (a sub total for each and a grand total) as well as a count of each other type of database object (a sub total for each category and a grand total). This add-in has not been posted yet to a web site as well so if you would like a copy please let me know. I have another add-in that will, among other things, document the User and Group permissions in a secured database. You can find that add-in on MVP Sandra Daigle's site here (at the top): http://www.daiglenet.com/msaccess.htm 2. David Hare-Scott has also written a simple table documentor. You can download it he http://www.rogersaccesslibrary*.com/...e-S*cott,David 3. Armen Stein has something here as well: http://www.jstreettech.com/cartgenie...rDownloads.asp (Look for Data Dictionary Report Utility) 4. You can buy a commercial product like this one that will produce a wealth of information: http://www.fmsinc.com/Products*/analyzer/index.html Hope that gives you some ideas. Let us know how it goes. -- Jeff Conrad Access Junkie Bend, Oregon |
#4
|
|||
|
|||
"Immanuel Sibero" wrote in message:
... Jeff, That's quite a wealth of information. I almost need a documentor just to document all the places where I can find all the various Access documentors. :-) Too brief you think? I'll go looking for some more. ;-) -- Jeff Conrad Access Junkie Bend, Oregon |
#5
|
|||
|
|||
First off THANKS YOU! The step in the doc
"Method 4 Use Regsvr32.exe to register the Accwiz.dll file again: 1. On the taskbar, click Start, and then click Run. 2. Type the following command in the Open box, and then click OK: Regsvr32.exe Accwiz.dll" Was the solution to the original problem. Did that and all was good. Now for your above and beyond (Thanks for that as well!) When I go to YOUR page I can't see anything to down load. I see a large image that does not load, a link for Doug Steel that seems to go no where and one for Arvin, does the same. I find similar problems when I try some of the others you recommended, I am not sure if it has something to do with our Corp Firewall, my stupidity (Likely one of those) or there is something wrong with the sites (I doubt, to many to be a coincidents). But I really do apprecite your help and hope you have a great week!! Rick "Jeff Conrad" wrote: "Rick" wrote in message: ... This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Humm, that's odd. I did some researching on Access 2003, Documentor, and the error message you mentioned, but did not find anything. I did find something concerning Access 2000 so perhaps this article will help in your situation. ACC2000: Error Message When Running Access Wizards: http://support.microsoft.com/default...b;en-us;303769 Try that and see if that gets the Documentor working. If you are interested in doing some documentation on your database without using the Documentor here are some other possibilities for you. 1. I have created a few add-ins that do some specific database documentation. My "Doug Steele Object Documentor" will create a nice report of all your database objects for easy reference. The report will list all the objects by category in alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in your database that you can open again any time you wish! There is one version for Access 97 and another version that works for 2000, 2002, and 2003. You can find the free Add-In on MVP Doug Steele's site he http://www.accessmvp.com/djsteÂ*ele/Documentor.html I also created an Access Add-In called the "John Viescas Table Documentor" that documents the table structures. It is even easier to use than the built-in Access Documentor and creates a slick report that will list each table (including linked ones) and their field properties in an easy-to-read format. I recently finished Version 2.0 of the add-in. This version even works on MDE files. This add-in has not been posted yet to a web site so if you would like a copy please let me know. I have another add-in called the "Albert Kallal Database Statistics" that will make a one-page report that lists the total number of lines of code in Modules, Forms, and Reports (a sub total for each and a grand total) as well as a count of each other type of database object (a sub total for each category and a grand total). This add-in has not been posted yet to a web site as well so if you would like a copy please let me know. I have another add-in that will, among other things, document the User and Group permissions in a secured database. You can find that add-in on MVP Sandra Daigle's site here (at the top): http://www.daiglenet.com/msaccess.htm 2. David Hare-Scott has also written a simple table documentor. You can download it he http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David 3. Armen Stein has something here as well: http://www.jstreettech.com/cartgenie...rDownloads.asp (Look for Data Dictionary Report Utility) 4. You can buy a commercial product like this one that will produce a wealth of information: http://www.fmsinc.com/ProductsÂ*/analyzer/index.html Hope that gives you some ideas. Let us know how it goes. -- Jeff Conrad Access Junkie Bend, Oregon |
#6
|
|||
|
|||
I was able to browse back then manually find yours at
http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I clicked the link myself it DNW. Thanks again! "Rick" wrote: First off THANKS YOU! The step in the doc "Method 4 Use Regsvr32.exe to register the Accwiz.dll file again: 1. On the taskbar, click Start, and then click Run. 2. Type the following command in the Open box, and then click OK: Regsvr32.exe Accwiz.dll" Was the solution to the original problem. Did that and all was good. Now for your above and beyond (Thanks for that as well!) When I go to YOUR page I can't see anything to down load. I see a large image that does not load, a link for Doug Steel that seems to go no where and one for Arvin, does the same. I find similar problems when I try some of the others you recommended, I am not sure if it has something to do with our Corp Firewall, my stupidity (Likely one of those) or there is something wrong with the sites (I doubt, to many to be a coincidents). But I really do apprecite your help and hope you have a great week!! Rick "Jeff Conrad" wrote: "Rick" wrote in message: ... This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Humm, that's odd. I did some researching on Access 2003, Documentor, and the error message you mentioned, but did not find anything. I did find something concerning Access 2000 so perhaps this article will help in your situation. ACC2000: Error Message When Running Access Wizards: http://support.microsoft.com/default...b;en-us;303769 Try that and see if that gets the Documentor working. If you are interested in doing some documentation on your database without using the Documentor here are some other possibilities for you. 1. I have created a few add-ins that do some specific database documentation. My "Doug Steele Object Documentor" will create a nice report of all your database objects for easy reference. The report will list all the objects by category in alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in your database that you can open again any time you wish! There is one version for Access 97 and another version that works for 2000, 2002, and 2003. You can find the free Add-In on MVP Doug Steele's site he http://www.accessmvp.com/djsteÂ*ele/Documentor.html I also created an Access Add-In called the "John Viescas Table Documentor" that documents the table structures. It is even easier to use than the built-in Access Documentor and creates a slick report that will list each table (including linked ones) and their field properties in an easy-to-read format. I recently finished Version 2.0 of the add-in. This version even works on MDE files. This add-in has not been posted yet to a web site so if you would like a copy please let me know. I have another add-in called the "Albert Kallal Database Statistics" that will make a one-page report that lists the total number of lines of code in Modules, Forms, and Reports (a sub total for each and a grand total) as well as a count of each other type of database object (a sub total for each category and a grand total). This add-in has not been posted yet to a web site as well so if you would like a copy please let me know. I have another add-in that will, among other things, document the User and Group permissions in a secured database. You can find that add-in on MVP Sandra Daigle's site here (at the top): http://www.daiglenet.com/msaccess.htm 2. David Hare-Scott has also written a simple table documentor. You can download it he http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David 3. Armen Stein has something here as well: http://www.jstreettech.com/cartgenie...rDownloads.asp (Look for Data Dictionary Report Utility) 4. You can buy a commercial product like this one that will produce a wealth of information: http://www.fmsinc.com/ProductsÂ*/analyzer/index.html Hope that gives you some ideas. Let us know how it goes. -- Jeff Conrad Access Junkie Bend, Oregon |
#7
|
|||
|
|||
OK, now maybe I am a bigger idiot than my wife reminded me I am this morning.
.. . When I try to run Dougs Documentor I get a runtime error " "The following error has occured: Error Number 7874 Error Description Microsoft Office Access can't find the object report1." I likely missed something along the way. I will tinker and try to figure it out. This DB HAS no reports yet, only tables. Maybe it is assuming at least one!? Rick "Jeff Conrad" wrote: "Rick" wrote in message: ... This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003 for a project, have created some tables and now want to use "Documenter" to create docs on the details of those tables. SO, just as I would in Access 97 I went to tools - Analyze - Documenter and I receive an "OK only" message box that says "There is no object in this control". When I click OK the documenter opens, but is empty, The messagebox reappears if I click any of the tabs. Is there something I have to do to make the objects in my new database documentable? Humm, that's odd. I did some researching on Access 2003, Documentor, and the error message you mentioned, but did not find anything. I did find something concerning Access 2000 so perhaps this article will help in your situation. ACC2000: Error Message When Running Access Wizards: http://support.microsoft.com/default...b;en-us;303769 Try that and see if that gets the Documentor working. If you are interested in doing some documentation on your database without using the Documentor here are some other possibilities for you. 1. I have created a few add-ins that do some specific database documentation. My "Doug Steele Object Documentor" will create a nice report of all your database objects for easy reference. The report will list all the objects by category in alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in your database that you can open again any time you wish! There is one version for Access 97 and another version that works for 2000, 2002, and 2003. You can find the free Add-In on MVP Doug Steele's site he http://www.accessmvp.com/djsteÂ*ele/Documentor.html I also created an Access Add-In called the "John Viescas Table Documentor" that documents the table structures. It is even easier to use than the built-in Access Documentor and creates a slick report that will list each table (including linked ones) and their field properties in an easy-to-read format. I recently finished Version 2.0 of the add-in. This version even works on MDE files. This add-in has not been posted yet to a web site so if you would like a copy please let me know. I have another add-in called the "Albert Kallal Database Statistics" that will make a one-page report that lists the total number of lines of code in Modules, Forms, and Reports (a sub total for each and a grand total) as well as a count of each other type of database object (a sub total for each category and a grand total). This add-in has not been posted yet to a web site as well so if you would like a copy please let me know. I have another add-in that will, among other things, document the User and Group permissions in a secured database. You can find that add-in on MVP Sandra Daigle's site here (at the top): http://www.daiglenet.com/msaccess.htm 2. David Hare-Scott has also written a simple table documentor. You can download it he http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David 3. Armen Stein has something here as well: http://www.jstreettech.com/cartgenie...rDownloads.asp (Look for Data Dictionary Report Utility) 4. You can buy a commercial product like this one that will produce a wealth of information: http://www.fmsinc.com/ProductsÂ*/analyzer/index.html Hope that gives you some ideas. Let us know how it goes. -- Jeff Conrad Access Junkie Bend, Oregon |
#8
|
|||
|
|||
"Rick" wrote in message:
... I was able to browse back then manually find yours at http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I clicked the link myself it DNW. Thanks again! The links work Ok for me. It does sound like maybe your company's firewall was interferring. -- Jeff Conrad Access Junkie Bend, Oregon |
#9
|
|||
|
|||
"Rick" wrote in message:
... OK, now maybe I am a bigger idiot than my wife reminded me I am this morning. . . When I try to run Dougs Documentor I get a runtime error " "The following error has occurred: Error Number 7874 Error Description Microsoft Office Access can't find the object report1." I likely missed something along the way. I will tinker and try to figure it out. This DB HAS no reports yet, only tables. Maybe it is assuming at least one!? Humm, since this is a "problem" Doug should be answering this one. (Sorry, inside joke) g I've been using the add-in for nearly a year and never ran into that error before. A couple things to try: 1. Compact the database. There could have been a residual temporary report in memory called Report1 that is in the System Tables. 2. Try running the add-in on a different database. Make sure it is a backup copy though. Any errors on this other file? Which Access version are you running by the way? -- Jeff Conrad Access Junkie Bend, Oregon |
#10
|
|||
|
|||
Hello,
I, too, am looking for an alternative to the built-in documenter. Please send me the "John Viescas Table Documentor" to . Thanks again. "Jeff Conrad" wrote: "Rick" wrote in message: ... I was able to browse back then manually find yours at http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I clicked the link myself it DNW. Thanks again! The links work Ok for me. It does sound like maybe your company's firewall was interferring. -- Jeff Conrad Access Junkie Bend, Oregon |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Email send problems with DSL & Outlook | bmcdermo | General Discussion | 3 | April 1st, 2005 02:43 PM |
Disconnect Problems with Sending Email | jeff | General Discussion | 4 | January 18th, 2005 06:36 PM |
Access Documenter in 2003 | Margaret | General Discussion | 7 | October 6th, 2004 05:22 AM |
problems initiating mplay32.exe | electricrainbowfish | Powerpoint | 8 | July 8th, 2004 09:37 AM |
Problems with Style formatting | terrapinie | Formatting Long Documents | 2 | July 7th, 2004 06:18 PM |