We help IT Professionals succeed at work.

How to properly document an access database

Davisro
Davisro asked
on
67 Views
Last Modified: 2019-04-17
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
Comment
Watch Question

Owner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
DavisroBudget Analyst

Author

Commented:
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...
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
No, it wouldn't cause TAA to fail. You can request a trial to be sure ...
DavisroBudget Analyst

Author

Commented:
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
Luke ChungPresident
CERTIFIED EXPERT

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.