Database documenter wanted

[Helge V. Larsen]

I do not like the database documenter in MS Access
(Tools/Analyze/Documenter). Therefore I have made a 'database documenter'
programmed in VBA. It documents the following:
Tables:
Table names
Number of records
Time for Last update
File name of external link (if linked table)
For each field:
Field name
Primary key (Part of -)
Field type (integer, long, text etc.)
Description
Queries:
Query names
SQL statements
The number of records retrieved (optional)
Forms, Reports, Modules, Macros:
Only the names of all forms, reports, modules and macros

I guess that others have made something similar - and probably better.
Could someone please supply me with links to good MS Access documenters -
freeware, please.

Helge

 

[Ken Snell \(MVP\)]

Perhaps this site will help:
http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

 

[Douglas J. Steele]

Take a look at what Jeff Conrad has at
http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

 

[Helge V. Larsen]

CSD Tools Database Documenter is a great tool !

BUT: It only reports the first 255 characters of each SQL command in EXCEL
query documentation.
In WORD and in 'internal report' the full SQL is reported.

Is it possible to persuade the master programmer to use probably no more
than ten minutes to report the full length of SQL commands ?
In return he will be awarded 1000 thanks from me!

Helge
______________________________________

 

[Helge V. Larsen]

CSD Tools Database Documenter is a great tool !

BUT: It only reports the first 255 characters of each SQL command in EXCEL
query documentation.
In WORD and in 'internal report' the full SQL is reported.

Is it possible to persuade the master programmer to use probably no more
than ten minutes to report the full length of SQL commands ?
In return he will be awarded 1000 thanks from me!

Helge
______________________________________

 

[Douglas J. Steele]

I suspect that's an Excel limitation, not an Access one.

 

[Helge V. Larsen]

You are right. It is a limitation in "Excel 5.0/95".

Therefore my plea should be:
Is it possible to persuade the master programmer to switch from "Excel
5.0/95" format to a newer Excel format ?
In return he will be awarded 10,000 thanks from me!

But who is the programmer of "CSD Tools Database Documenter" ?

Helge
______________________________________

 

[Helge V. Larsen]

You are right. It is a limitation in "Excel 5.0/95".

Therefore my plea should be:
Is it possible to persuade the master programmer to switch from "Excel
5.0/95" format to a newer Excel format ?
In return he will be awarded 10,000 thanks from me!

But who is the programmer of "CSD Tools Database Documenter" ?

Helge
______________________________________

 

[Douglas J. Steele]

Jeff Conrad wrote it.

I'll point him to this thread and we'll see whether he replies.

 

[Jeff Conrad [MSFT]]

Hi Helge,

I originally wrote the utility to be compatible with as many Access versions
as possible. My former employer still uses Access and Office 97 so I had to
make sure it could work in my daily activities.

I have a long list of improvements/enhancements/bug fixes to make to the
tool, not the least of which is to make a 2007 compatible version. My free
time, however, is quite limited so it might be some time before I can get
around to working on the tool.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com