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
DatabasesMicrosoft Access

Avatar of undefined
Last Comment
Luke Chung

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Davisro

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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Scott McDaniel (EE MVE )

No, it wouldn't cause TAA to fail. You can request a trial to be sure ...
ASKER
Davisro

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Luke Chung

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