This project has moved and is read-only. For the latest updates, please go here.
To document your SQL Server databases:
  1. create an Access database with links to your SQL Server tables
  2. be sure to save the username and password in the connect string -- it can be read-only (after the Analyzer is done, you can delete the Access database if desired)
  3. Close the database with links.
  4. Download the free Analyzer for Microsoft Access
  5. Open the Analyzer
  6. Browse to the Access database with linked tables
  7. Run the Analyzer (It takes awhile to run if you have a lot of data and choose the Value Analysis test. While running, you will see "Not Responding". This is normal and nothing to be concerned about.)
  8. Look at reports

Last edited Dec 7, 2016 at 8:18 AM by strive4peace, version 1