Database maintenance & modification

[Guest]

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!

 

[Guest]

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/conradsystems/accessjunkie/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/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________