Background

Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals. 

Question

Does Total Access Analyzer document the fields and data types of linked SQL Server Tables?

Answer

Yes, it documents the field data types of linked tables, but for the data types that Access interprets them to be. Not the data types that are on the source database in SQL Server.

For instance, SQL Server may have a field that’s of type nvarchar, and Access would interpret is a Text field and Analyzer will document it as a Text field.

Total Access Analyzer documents all tables in the current Access database and its linked tables. If the linked tables are in SQL Server, it documents all the fields of those tables (assuming the linked tables are saved with the permissions to allow them to be opened from Access).

From there, the table and field reports would show the data types.
Here's an example of fields in each table: http://fmsinc.com/MicrosoftAccess/Documentation/Reports/Table_FieldsByTable.html

There are many other reports related to tables that are linked from that page. There are also reports sorted by Data Type though we currently don't have an example online.

Data Type Analysis is performed to find inconsistencies for field definitions of identically named fields, which includes the SQL Server tables: http://fmsinc.com/MicrosoftAccess/Documentation/Reports/Suggestion_Table_Fields_DifferentTypes.html

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
•  PDF Fact Sheet