| Total Access Analyzer | |
|
Microsoft
Access 2007 Version
Versions also |
|
| Analyzer Info: | |
|
Best Practices (Errors, Suggestions, and Performance Tips) Finding Unused Objects and Code
|
|
| Why Analyzer? | |
|
for Users, Developers & Consultants |
|
|
|
|
| Additional Info: | |
|
|
|
|
|
|
Total Access Analyzer Version 10.5
The current version of Total Access Analyzer 2002 is version 10.7. This significantly improved version of Total Access Analyzer 2002 is available for free to premium support subscribers or a small upgrade fee. Click here for more information, or click here to upgrade from Total Access Analyzer version 10.0 or 10.5 to version 10.7.
Although you can no longer purchase Version 10.5, this information is provided as a resource if you upgraded to it in the past.
New Features and Enhancements in Version 10.5
The 10.5 update introduced several new features and enhancements:General
- Documentation is generated faster.
- The "New Values" field property for AutoNumber fields ("Increment" or "Random") is documented.
Table Documentation
- For MDBs and MDEs, table documentation includes an estimate of table size. This information appears a new Table List Report, as well in reports that show table record counts.
- The Table Index Properties report displays the index field names along with its properties.
Error, Suggestion, and Performance Issue Detection
- Table and query names that contain characters that conflict with SQL Server.
- Table and query names and fields that conflict with Access/Jet reserved words.
- Tables and queries with undefined datasheet font name.
- Forms and reports without a RecordSource are listed as one error, which notes that the form or report has no RecordSource, and lists the number of bound controls.
- Forms and reports with controls that should have an associated label, but do not.
- Form option groups that have duplicate values.
- Form and Report controls that have different shortcut keys for the same control.
- Form and Report controls that use a space as a shortcut key.
- Form and Report controls that have a shortcut key, but no associated control.
- Database with the "Always Use Event Procedures" setting off.
- Databases with small MRU lists.
- Databases with the "Confirm Document Deletions" setting off.
- Relationship errors due to invalid fields, foreign table fields, and foreign tables are flagged separately. Previous versions of Total Access Analyzer listed one generic error for the relationship.
