Hi Pete,
CSD Tools is a good utility to use for documenting a database, and it's
free. The only requirement is that you have to admit that you are an Access
Junkie!
http://home.bendbroadband.com/conrad.../csdtools.html
Total Access Analyzer from FMS is a very good tool for documenting Access
applications. A single user license runs US $299:
http://www.fmsinc.com/products/analyzer/index.html
I use both products, and have been very happy with them.
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
"Pete Rothery" wrote:
> I have a database running on a network with multiple users. It has been
> developed over a two year period to cater for everyone's needs and ideas. I
> have not documented either the original design or the modications: as aresult
> it is inreasingly difficult to make further modifications as I have to work
> out how everything functions from scratch.
>
> This is completely my own fault but I would appreciate any suggestions on
> how to improve the situation.
>
> The db has 23 tables, 44 queries, 35 forms & 25 macros. Maybe its not that
> complicated but it is enough to give me headaches!