Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, features both new and old. and discontinued features.
It’s hard to remember all the changes. Fortunately, we created a comparison matrix that shows the different Microsoft Access versions and changes. See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old.
We are pleased to introduce new versions of Total Access Statistics for Microsoft Access 2007 and 2003; versions 12.9 and 11.9 respectively. They include the many features we introduced with the latest Access 2016 version.
Total Access Statistics is an add-in that is the most powerful data analysis program for Microsoft Access. It extends the power of Access queries to analyze the data in your local or linked tables. It generates results in tables you can view or include in other queries, forms, and reports. It offers a wide range of statistical functions such as:
Field Descriptives
Financial Cash Flow Calculations
Percentiles
Running Totals and Moving Averages
Field Comparison
Frequency Distributions
Regressions
Advanced Cross-Tabulations
Group Analysis (t-Tests and ANOVA)
Record Analysis and Rankings
Non-Parametric Analysis
Probability Calculator
New Features
Additional percentile types can be assigned to a field in your table
Enhanced data formatting
Improved financial calculations for IRR and XIRR
Updated user manual
Support for Windows 8 and 10
New Add-in and Runtime Library Files
Version 12.9 and 11.9 include new files for the Access add-in. It also has new runtime library files.
A digitally signed MDE library for MDB databases that support users of Access 2016, 2013, 2010, 2007 and 2003.
The Access 2007 version includes an ACCDE runtime library for ACCDB databases for Access 2016, 2013, 2010 and 2007 users
The Access 2003 version includes a runtime library for Access 2000 and 2002 users
Total Access Startup makes it easy to centrally manage all your Microsoft Access database deployments. Ensure that all your users run the latest version of your database application with the right version of MS Access. Easily deploy updates without having to manually change things on each user’s PC. Simply point your users to a shortcut and they never need to know the actual name of the database.
Total Access Startup 2016 is now shipping to let you:
For optimal performance, deploy a local copy of your master database on each user’s PC and keep it updated when you update the master
Run it with a specific Access version or a range of allowable Access versions. This makes it easy to support legacy versions of Access even if users install later versions of Office/Access.
Specify the bitness (32 and/or 64-bit) that are allowed for Access 2010, 2013, and 2016.
Display a professional splash screen graphic while your database loads
If your users can’t launch your database, a message appears with information you provide to contact you. You can customize our messages or translate them to your user’s language.
In conjunction with the release of Total Access Analyzer for Microsoft Access 2013, FMS is pleased to release updates for earlier versions of MS Access:
Click on the links for detailed information on the new features.
Background
Total Access Analyzer is the most popular Microsoft Access add-in of all time. It provides detailed documentation and analysis of your MS Access databases to help you better understand how your objects work together, detect problems, improve your designs, and enhance performance.
This update is part of the 10th major release of Total Access Analyzer since its debut in 1993.
Free Demo
A demo is available for you to see the types of documentation it generates using the sample Northwind database. Look at the results, filter and search it, and see the reports it generates: Demo Download
Existing Customers
Customers on an annual support contract for Total Access Analyzer or the suites it’s in receive the new versions for free:
The release of Total Access Admin 2013 added many new features. Due to customer demand, we’ve updated Total Access Admin 2003 from version 11.5 to 11.6 to include the new features.
The primary difference between the 2003 and 2013 version is that the 2003 version doesn’t require installing Access 2007 or later on the machine in order to support the ACCDB database format. It supports Access databases in MDB formats and does not require Access to be installed on the PC.
Many New Features
Total Access Admin 2003 version 11.6 includes these enhancements:
Maintain a list to translate computer names to more friendly user names
Manage up to 100 database in one screen (up from 50)
An update of Total Visual CodeTools 2010 is released with support for Microsoft Office/Access 2010, 2007, 2003 and Visual Basic 6.0. Several enhancements were made to improve the New Procedure Builder, VBE color scheme builder, icons for the toolbars, setup program and IDE integration, etc. Here are the details on the latest enhancements of Total Visual CodeTools.
Total Visual CodeTools is an add-in to your Office/Access/VBA and VB6 integrated development environment (IDE) that helps you write, clean-up and deliver better solutions. Available from the IDE menu or a toolbar, a variety of tools help increase your efficiency and consistency when writing code and taking over someone else’s work. Features include:
Code Builders to create new procedures, properties, ADO and DAO recordsets, message boxes, select case statements; convert SQL strings, copy control event procedures, use the Format and DateDiff functions, comment blocks of text, etc.
Cleanup Existing Module Code by adding Option Explicit, standardizing formatting, adding error handling to procedures that lack it, rename variable names to your convention, etc.
We are very pleased to release an update to Total Access Statistics for Microsoft Access 2010, 2007, and 2003. If you are an owner of version 14.0, 12.8, and 11.8 respectively, you can download the update at no charge.
Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the data analysis capabilities of Access queries to let you perform advanced numerical analysis on your data. Use any Access table, linked table, or query to perform calculations such as percentiles, regressions, frequency distributions, t-Tests, correlations, non-parametrics, rankings, moving averages, etc. It can also perform data normalization and let you select random records. As you would expect in a query, you can specify Group By fields so analysis is performed on each set of records with identical group fields. Total Access Statistics runs within Access with all output in Access tables. It supports MDB, ACCDB, and ADP databases.
The update includes these enhancements:
Significant performance improvements when processing large numbers of records
While analyzing records, a new status form appears with an option to cancel the process
Setup program offers machine or current user installation options
On August 14, 2012, Microsoft released a security update for Microsoft Office that includes an update to the Windows Common Control MSCOMCTL.OCX.
Unfortunately, this update causes problems with existing Microsoft Access, Visual Basic 6, and other applications that use the common control such as the Treeview and ListBox controls. For us, this impacts our Total Access Analyzer program which uses the Treeview control in its database explorer feature. It triggers this error:
Microsoft provides a workaround for this problem in a Knowledgebase article, but it doesn't always work. We've come up with a solution that addresses this problem reliably.
In addition to the comprehensive documentation and analysis of your database objects, macros, and VBA module code, Total Access Analyzer version X.9 adds:
Detection of Additional Errors and Suggestions
Timer Interval and Timer Event Mismatch
Queries Using Other Queries with Both having GroupBy Clauses
Action Queries Opened by OpenQuery Command
SQL Server list of reserved words updated for SQL Server 2012
Displaying Additional Documentation Results
ActiveX controls appear as a New Category under General
New Table-Fields folder under Tables lets you view field properties across all your tables in one screen
Enhanced Opening of Referenced Object in Design Mode (view the documentation and immediately jump to the object to make changes)
Report Enhancements
Preview Multiple Reports at One Time
Color Customization for Reports
Enhanced Macro Dictionary Report
Many New Reports
New Module VBA Documentation and
Options for Microsoft Access 2007
Improved User Experience
Support for Windows 7 (in addition to XP and Vista) and Office Themes
Installation options for the current user or machine, with support for User Access Control permissions
Existing customers with premium support subscriptions receive the upgrade for free. Other existing customers can upgrade for a nominal fee. The free trial download is available.