Link to home
Start Free TrialLog in
Avatar of Davisro
DavisroFlag for United States of America

asked on

How to properly document an access database

Experts,

Can anyone point me to a resource on the proper way to document an Access database? I have a 14 year old departmental database with 1,000+ tables and queries, of which I don't yet know how many are active or artifacts and I need to high-level document it for the department but also in more detail for myself. I know FMS has software...although I'm not sure I can install it on my system. How would you go about doing it?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Davisro

ASKER

Thanks...when I attempt to use the native Object Dependencies feature, it fails because when I run it, there are about 30 parameter queries that ask for inputs as its running and I don't know the parameters. In addition, its been running for 30 minutes and still no result...I'm wondering if that would cause the FMS software to fail as well...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No, it wouldn't cause TAA to fail. You can request a trial to be sure ...
Avatar of Davisro

ASKER

And FMS doesn't require administrator rights to install. That's a great thing...

Thanks to all. Giving points to John as well...you never know, I may need to go that route
Thanks for the kind words about Total Access Analyzer. I'm the primary author of the product and founder of FMS, Inc. We don't have a trial version that runs against your database. Our demo shows the documentation of Northwind.

Total Access Analyzer documents all the objects and how they interact with each other. It detects over 300 types of errors, suggestions, and performance issues. It should pay for itself the first time you run it. It comes with a 30 day money back guarantee.

More info here http://fmsinc.com/MicrosoftAccess/BestPractices.html