Dec 20

Total Access Analyzer 2019 is Shipping

real-time-monitortotal-access-analyzeranalyzer-icon

We are excited to announce the release of Total Access Analyzer for Microsoft Access 2019! Total Access Analyzer examines all your database objects to provide extensive documentation, code analysis, object cross-reference, and diagrams with over 390 presentation-quality reports.It detects 300+ types of errors, suggestions, and performance tips, so you can learn and apply Best Practices to fix problems, improve your design, and speed up your Access applications.>New Features

Access Analyzer 2019 is an upgrade from the 2016 version and includes these enhancements:

  • analyzerSupports Microsoft Access 2019, 32-bit and 64-bit versions.
  • Document All Database types supported by Microsoft Access 2019.
  • Improved Blueprint Documentation.
  • Additional Cross-Reference and Validation including Subform References.
  • Improved Memory Management.
  • Data Macro Documentation.
  • Document Workgroup Security in ACCDBs.
  • Better Support of Documentation for Multiple Databases.
  • Module Bracket Reports.
  • Improved User Interface Shows more Progress Details.
  • New Manual and Context Sensitive Help.
  • and more

Existing Total Access Analyzer owners are able to upgrade at a discounted price.


New updates for Total Access Analyzer 2016, 2013, 2010 and 2007

Enhancements

  • Additional Cross-Reference and validation of tables, queries, fields and controls across your database objects, including references in subforms.
  • Improved form and report blueprint documentation to capture large and complicated designs and layouts.
  • Improved memory management for documenting large Access databases to minimize the chance of running out of memory.
  • Data macro documentation and cross references to related tables.
  • Documentation of workgroup security settings for ACCDBs if they wer converted from MDBs with workgroup security.
  • Improved user interface to show progress of the documentation.
  • Revised user manual and help file.
  • and more…

For more information, visit:

Download the Free Trial to experience it for yourself.

May 19

Total Access Detective Update for Microsoft Access 2016, 2013, 2010 and 2007

Total Access Detective finds differences between Microsoft Access databases and objects. Updates for Total Access Detective are available for Microsoft Access 2016, 2013, 2010 and 2007.

Enhancements:

  • Improved SQL string comparisons for saved queries and properties like RecordSource and RowSource.
  • Trailing blank spaces and extra blank lines are removed before comparing them, this avoids flagging SQL string differences that do not affect functionality.
  • Query comparison. Under Data Options, if the query option is set to First Field Unique, it was always treating them sequentially and stopped on the first difference. This is fixed and works correctly.
  • Table macro comparison supports table names with apostrophe (‘) in the them.
  • Text comparison. If the VBA option is not selected, the results do not show the the Procedure tabs.
  • Database comparison results: The database name goes across the entire top of the form rather than being truncated.
  • All other reported issues.

For more information, visit:

Existing Total Access Detective owners were notified to download the update.

Total Access Detective Updates

Feb 21

Microsoft Access Version Comparison Matrix

microsoftboxes2013Microsoft 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.

Visit our page: Microsoft Access Version Features and Differences Comparison Matrix

feature-matrix

 

Feb 21

Total Access Statistics Updates for Access 2016, 2013, 2010, 2007, and 2003

New versions of Total Access Statistics are available for Microsoft Access 2016, 2013, 2010, 2007, and 2003.

Enhancements:statistics

  • 2016, 2013, 2010, 2007, and 2003 Versions:
  • Adjusted treatment of null values as missing values rather than zero
  • Updated digital signature for Runtime MDE (for MDB databases)
  • Enlarged the field selection forms

For more information, visit:

Existing Total Access Statistics owners were notified to download the update.

Aug 17

Total Access Emailer Version X.7 for Microsoft Access 2013, 2010, and 2007

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email

With the recent release of Total Access EmailerTotal Access Emailer for Microsoft Access 2016, we are pleased to release updates of earlier versions to include the many new features:

  • Total Access Emailer 2013, Version 15.7
  • Total Access Emailer 2010, Version 14.7
  • Total Access Emailer 2007, Version 12.7

Total Access Emailer is the most popular email blaster for Microsoft Access. Easily send personalized emails directly from your Access database. Quickly communicate with every email address in your table or query. Use fields from your data source to customize each subject and message. Attach files from disk and also attach reports as PDF files filtered for each recipient.

The new X.7 version includes many new features since their previous version:

  • email-validationEmail Validation to check the syntax of the values in your email field so you can flag invalid emails in your table before you send your blast
  • Save Attached Files to Disk. This lets you document the attached files sent to all your contacts without using blind cc (Bcc).
    • This can also be used independent of sending emails as a way to distribute files and PDF reports to disk. You can even create folder names based on field values.
  • Preview Saving Files to Disk
  • New VBA Function to Preview Email Blasts with Save Files
  • Code Generator Supports Preview Email with Save Folder
  • Support for Office365 and other SMTP Services using TLS
  • Enhanced setup for Windows 10 and 64-bit installations
  • Updated user manual and help file
  • Complete list and additional details of new features in Total Access Emailer X.7.

download-trial-blueDownload the free trial version and send your own personalized emails from Microsoft Access.

Create multiple email blasts in your database and run them at any time through the Total Access Emailer add-in Wizard:

Main Screen of Total Access Emailer 2016

Apr 15

Total Access Startup Available for Microsoft Access 2016 and 2013

total-access-startupTotal 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.

overview

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.

startupMore Resources

Total Access Startup is also part of the Total Access Ultimate Suite. Existing Total Access Startup customers can upgrade at a discounted price.

Mar 09

Microsoft Office 2010 Update KB3085515 Causes Access ACCDE and MDE Databases to Crash

Access2010-boxMajor Alert: Office Update KB3085515 Breaks Microsoft Access 2010 Databases in ACCDE and MDE Formats

On March 8, 2016, Microsoft released an update KB3085515 for Office 2010. It addressed some VBA issues for Excel.

Unfortunately, the update of the VBE7.DLL file causes many Microsoft Access databases to fail. A heated thread on the Microsoft Community forum describes the problem: KB3085515 breaks MS Access 2010 reference

The updated file is:

C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA7\VBE7.DLL

Fix

Microsoft released an update that fixed this problem: Office 2010 Update KB3114989


The information below is from the original diagnoses of the problem

Impact

We are still determining the full impact of this bug. We know this impacts wizards in Access and customers of our Microsoft Access add-ins. It also impacts the people you support with our runtime distribution libraries referenced from your MS Access databases. At the very least we know it prevents running:

  • Microsoft Access databases in ACCDE and MDE formats (defined below).
  • Databases (ACCDB or MDB) with library references to ACCDE and MDE files.
  • Built-in MS Access 2010 Wizards that are ACCDE files.

ACCDE and MDE Database Formats

ACCDE and MDE databases are “compiled” versions of ACCDB and MDB database formats where form and report design changes can’t be made and VBA modules can’t be viewed or edited. They are “locked” to referenced DLLs, libraries, and other dependencies that can change over time…provided those dependencies follow Windows protocol for binary compatibility to identify new versions.

Unfortunately, the Microsoft Excel update of the VBE7.DLL file broke the VBA dependency by not creating the new version correctly. That causes previously developed ACCDE and MDE databases to stop working. This was not an issue for the Excel community since they don’t have an equivalent “compiled” version of Excel spreadsheets (the VBA code is always exposed behind spreadsheets), but it kills Access Wizards and the ACCDE and MDE databases people create.

Microsoft Access 2010 Add-ins Won’t Run

In addition to causing some Microsoft wizards in Access to fail, our Microsoft Access 2010 add-ins won’t run since they are Access databases in ACCDE format. You may see messages like this when you try to launch them:

  • Microsoft Access can’t start the wizard, builder, or add-in.
  • This feature isn’t installed, or has been disabled.

There may be suggestions to reinstall the add-in but that won’t help. This impacts these of our products:

Microsoft Access ACCDE Libraries

Some of our products include ACCDE runtime distribution libraries that let you incorporate our product’s features in your application for distribution to your users. You and your users are impacted by this problem and may experience messages like these:

  • The code contains a syntax error, or a Microsoft Access function you need is not available.
  • File format no longer supported.

Customers using our redistributable runtime libraries in databases distributed to their users are impacted:

Microsoft’s Response

The Microsoft Access development team is aware of this problem and is working on a solution as we speak. Microsoft has already stopped people from downloading the update and thankfully didn’t release a similar update for Office 2013 and 2016. They’ve also published this blog post:

You may encounter errors with your ACCDE/MDE files and/or wizards after installing the March update for Office 2010 (KB3085515)

The hope is for a new update that fixes this problem. Timing of when that will be available is unknown, but we’ll keep you informed as we learn it.

Current Solution: Uninstall the Update

The only solution is to uninstall the update. You can uninstall it from:

  • Command line, or
  • Control Panel.

Run a Command Line

You can run this line from the command prompt or put it in a BAT file if you want to share it with others: Note that we have reports that this may not work for everyone since it requires certain permissions:

wusa /uninstall /kb:3085515 /quiet /norestart

Uninstall from the Control Panel

The patch can be uninstalled from the Control Panel, Windows Update program: WindowsUpdate In Windows 10, from the Windows Update screen, click on the Advanced options hyperlink: windows10-update then click on View your update history: windows10-update-historyChoose Uninstall updates to see the list of installed updates: windows10-update-uninstall For Windows 7, click on the View update history link on the left border: windows-update-history From the top section, click on the Installed Updates link: windows-update-installed

List of Installed Updates

View the list of Windows updates installed on your PC, grouped by product which are collapsible. Go to the section Microsoft Office Professional Plus 2010 (or equivalent): windows-update-uninstall Find the KB3085515 update, click on it to uninstall and confirm it.

Aug 24

Total Access Analyzer 2010, 2007 and 2003 Updates Ship

Total Access AnalyzerIn 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:

Other Total Access Analyzer customers can upgrade for a discounted price.

Nov 05

Total Visual SourceBook 2013 Ships

Total Visual SourceBook Total Visual SourceBook

We are delighted to announce the release of Total Visual SourceBook 2013. Total Visual SourceBook is our royalty-free source code library for Microsoft Access/Office VBA developers and Visual Basic 6 (VB6) developers.

code-explorer-web

The new 2013 version is an upgrade to our Total Visual SourceBook 2007 version. The new version is especially designed for the new features introduced in Microsoft Access/Office/VBA 2013 and 2010. It can also run in Access/Office 2007 and older versions through Access/Office 2000.

New Features

Total Visual SourceBook 2013 includes 35 new modules, 25,000+ more lines of code, enhancements to existing modules including VBA code that’s compatible with 32 and 64-bit versions of Office.

The user code database can now be upsized to SQL Server to simplify sharing code among your developer team. The new version also includes many enhancements to the code browser to simplify your experience in viewing, searching, adding, editing, and applying different error handlers to the source code.

For a complete list of enhancements, visit our New Features page.

Additional Resources

Aug 26

Free Update for Total Access Analyzer 2010 and 2007

Total Access AnalyzerTotal Access Analyzer is the most popular Microsoft Access add-in of all time. Analyzing all the objects and code in your database, Total Access Analyzer generates detailed documentation and detects 300+ ways to fix, improve, and speed up your Access applications.

We have released free updates of Total Access Analyzer 2007 and 2010 to existing customers:

The updates include the following fixes and enhancements:

  • Module Cross-Reference incorrectly listing procedures that didn’t exist when they existed
  • Improved SQL query parsing to better cross-reference table and field names passed as function parameters
  • For secure databases, document queries even when logged in without admin rights
  • Support documenting library references of long DLL file names and paths
  • Setup issues resolved for certain machines and motherboards
  • For Microsoft Access 2010’s 64-bit version, support for Windows 8

Existing customers were already notified with download instructions.