|
|
Tool > Document > Analyzer
|
|
|
The Deep Analysis report gives everything you'd see in a data dictionary with depth.
video: Analyzer for Microsoft Access - free tool to see what's in your database
Download Analyzer_211125_s4p_update-vbw-Peter_ACCDB.zip (12mb)
This is a zipped up ACCDB file. vbWatchdog (global error handler) updated by Peter Cole on behalf of Wayne Phillips ( vbWatchdog on EverythingAccess.com)
Remember to UNBLOCK files you download to remove the Mark of the Web. Here are steps to do that: https://msaccessgurus.com/MOTW_Unblock.htm
If you have a problem, try Compact/Repair. If you still have a problem, Compile and then Compact/Repair again. Did that fix it? If not, write to me, thank you.
Feedback is good (thanks to all of you who write!) ... and donations are much appreciated, thank you.
For years, I've been documenting databases. Others like to document as well and originally I got talked into sharing source code for the Analyzer, which I did.
Then I got talked into making the Analyzer an open source, collaborative project, which I did. CodePlex was Microsoft's sharing site for developers. Little did I know it was not to last. Now the site is archived so you can see everything that was posted, but content can't be updated. The Analyzer got a lot of care and attention. Thanks to Graham, Wayne, Mark, James, Henry, Adrian, Bill, Anders, and many others who helped the Analyzer get wings*.
Then the Analyzer went to GitHub. There hasn't been any collaboration that I'm aware of, but something about the file is different, and I have errors with it too.
So what to do to ensure that the download file is as posted? I guess I'll just post it myself, as I did so long ago, so here it is!
Over the years, many of you have written to me about the Analyzer, thank you.
* Had that collaborativeness lasted, it would have been great! But alas, cold water got sprinkled on the hot fire by those who didn't want to share. As a teacher, I'm happy to share ... So rewarding to see what others do too.
So the Analyzer is back to being changed by mostly me. If you have ideas to make it better, and funds to make it happen, or just one or the other ... let me know!
If the Analyzer has helped you, and you have extra, donate, even if its just a little - everything is much appreciated. It takes time to make things better and once I dig in, I like to spend a week or 2 ...
Let's connect. If you're using Access and need to clear the cloud, get a strong foothold, good foundation, and clear path, let's connect. I've got hundreds of objects and thousands of code snippets we can pull in as needed. It would be my pleasure to help you.
Email me anytime at training@msAccessGurus
I look forward to hearing from you
~ crystal