Access Documenter

[The Wise Monkey]

I've been creating a pretty complex database for my A Level computing
project and recently ran the Access documenter on All Objects in order
to see what there was. However, I soon got fed up of waiting for it to
finish and so pressed Ctrl + Break to stop it, as suggested by the
little status bar at the bottom of the generated report.

This wasn't the main problem though. After exiting the database,
compacting and repairing along the way, I discovered that my database
had grown by 30 MB for no apparent reason. I had not done anything else
to it, so I guessed that the documenter is the source of the problem.

Does anyone have any idea about what I can do to delete the
half-created documentation that resides somewhere in my database but I
cannot get to? I tried using the Microsoft Access Help, but it was to
no avail.

Any input is much appreciated, thanks very much.

 

[Douglas J. Steele]

Actually, the documenter doesn't store its data in your database, but it a
separate database.

It could be that you've got some corruption in the database. Try making a
copy and decompiling the copy, then compacting a couple of times. Read what
Michka has to say about decompiling first, though:
http://www.trigeminal.com/usenet/usenet004.asp

 

[Joseph Meehan]

I've been creating a pretty complex database for my A Level computing
project and recently ran the Access documenter on All Objects in order
to see what there was. However, I soon got fed up of waiting for it to
finish and so pressed Ctrl + Break to stop it, as suggested by the
little status bar at the bottom of the generated report.

This wasn't the main problem though. After exiting the database,
compacting and repairing along the way, I discovered that my database
had grown by 30 MB for no apparent reason. I had not done anything
else to it, so I guessed that the documenter is the source of the
problem.

Does anyone have any idea about what I can do to delete the
half-created documentation that resides somewhere in my database but I
cannot get to? I tried using the Microsoft Access Help, but it was to
no avail.

Any input is much appreciated, thanks very much.

Try a compact and repair. That should take it back. I don't recall for
sure, but I seem to remember that it may create a new table while doing a
documentation. You may need to delete that table before doing the compact.

 

[Albert D. Kallal]

There is a report that it creates...perhaps you can go into the report view,
look for the report. I also believe a table is created.


Another possible fix is to simply create a blank database, and import all
objects from the old one.

This often leaves behind some 'un-finished object. And, while the copy
goes..you can watch if it gets stuck on some large object, or table....