> This appeared to be the best place for this question as it has to do with
> wanting to represent my table layouts.
[quoted text clipped - 12 lines]
> 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.aspx?scid=kb;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 here:
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 here:
http://www.rogersaccesslibrary?.com/OtherLibraries.asp#Hare-S?cott,David
3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.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.

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
Immanuel Sibero - 08 Apr 2005 21:19 GMT
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
> > This appeared to be the best place for this question as it has to do with
> > wanting to represent my table layouts.
[quoted text clipped - 77 lines]
> Hope that gives you some ideas.
> Let us know how it goes.
Jeff Conrad - 08 Apr 2005 21:40 GMT
> 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.
;-)

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
Rick - 11 Apr 2005 14:33 GMT
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
> > This appeared to be the best place for this question as it has to do with
> > wanting to represent my table layouts.
[quoted text clipped - 77 lines]
> Hope that gives you some ideas.
> Let us know how it goes.
Rick - 11 Apr 2005 14:39 GMT
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!
> First off THANKS YOU! The step in the doc
> "Method 4
[quoted text clipped - 102 lines]
> > Hope that gives you some ideas.
> > Let us know how it goes.
Jeff Conrad - 11 Apr 2005 19:40 GMT
> 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.

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
Luther - 09 Aug 2005 21:52 GMT
Hello,
I, too, am looking for an alternative to the built-in documenter. Please
send me the "John Viescas Table Documentor" to lbernadel@cdc.gov.
Thanks again.
> > I was able to browse back then manually find yours at
> > http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I
[quoted text clipped - 4 lines]
> The links work Ok for me.
> It does sound like maybe your company's firewall was interferring.
Jeff Conrad - 09 Aug 2005 22:46 GMT
Elements of that code have been rolled into a much larger
database documentation tool. You can download the
free add-in from my site here:
CSD Tools Add-in Page:
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html
(Watch out for any line wrapping on that link).
There is one version for Access 97 and one version that
works with Access 2000, 2002, and 2003. Make sure
you download and install the correct one.

Signature
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
> Hello,
>
> I, too, am looking for an alternative to the built-in documenter. Please
> send me the "John Viescas Table Documentor" to <<e-mail snipped>>
> Thanks again.
Luther - 09 Aug 2005 23:06 GMT
Thank you...
> Elements of that code have been rolled into a much larger
> database documentation tool. You can download the
[quoted text clipped - 13 lines]
> > send me the "John Viescas Table Documentor" to <<e-mail snipped>>
> > Thanks again.
Jeff Conrad - 10 Aug 2005 02:43 GMT
No problem.
Hope it helps in your projects.

Signature
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
> Thank you...
Rick - 11 Apr 2005 14:46 GMT
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
> > This appeared to be the best place for this question as it has to do with
> > wanting to represent my table layouts.
[quoted text clipped - 77 lines]
> Hope that gives you some ideas.
> Let us know how it goes.
Jeff Conrad - 11 Apr 2005 19:44 GMT
> 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 "
[quoted text clipped - 6 lines]
>
> 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?

Signature
Jeff Conrad
Access Junkie
Bend, Oregon