Dec 18

Total Access Analyzer Available for Microsoft Access 2016

Total Access Analyzer, the most popular Microsoft Access add-in, is now shipping for Microsoft Access 2016.

Total Access Analyzer offers comprehensive documentation and analysis of your MS Access databases so you can better understand individual objects, cross-references between objects, procedure and data flow diagrams, VBA module analysis, and much more. Detecting over 300 ways to fix and improve your databases, Total Access Analyzer improves the quality of your work, teaches you best practices for Access application development, and increases your productivity.

main-menu-2016

New FeaturesTotal Access Analyzer

  • Support for Microsoft Access 2016, 32 and 64 bit versions
  • New Suggestion: Incorrect Link to Subforms
  • New Suggestion: Relationship Field Cross-Reference and Field Type Comparison
  • Enhanced Cross-Reference of Aliased Tables in Queries
  • Pass-Through Queries are Not Cross-Referenced
  • Windows 10 Support
  • New Manual and Context Sensitive Help

For additional details, visit New Features in Total Access Analyzer 2016 for the enhancements since the Access 2013 version. Existing customers can upgrade at a discounted price. A demo version is available.

Dec 18

Total Access Detective Available for Microsoft Access 2013 and 2016

We are delighted to announce the release of Total Access Detective for Microsoft Access 2013 and 2016. Total Access Detective lets you quickly find differences between any two databases or two objects in your current database, know exactly what changed at the table, field, property, control, macro line and VBA module code level. You can even compare tables for data differences.

Main Menu for Comparing Two Databases

main-menu-2016

Add-in Menu to Launch Total Access Detective to Compare Two Objects in the Current Database

addin-menu

The Object Comparison Wizard:

two-object-selection

Enhancementsdetective

The latest version offers many enhancements from the previous versions:

  • Support for the 32 and 64-bit versions of Access 2016 and 2013
  • Module and Text Comparison Option to Ignore Line Numbers
  • Search Bar to Filter Objects and Properties by Name
  • See and Filter Tables based on Whether it’s Linked
  • Procedures with Differences List
  • New Manual and Help File

For more information on the enhancements, visit: New Features in Total Access Detective 2016 and 2013

Existing Total Access Detective customers can upgrade for a discounted price.

Oct 21

Microsoft Access 2016 and Invisible Picture Images

December 8, 2015: Microsoft released an update that addresses this issue. Information and downloads are available here: Microsoft Access/Office Updates for December 2015. Updates were provided for Access 2016 and 2013, plus Office 2016, 2013, 2010, 2007, and 2003. Note this issue never affected Access 2013. Here is the KB Article and download for Access 2016. We’ve updated our Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History with the new updates.
NOTE: When we downloaded the update for 2016, we received build 16.0.6001.1038 dated 01-Dec-2015. That’s different from the 08-Dec-2015 announcement which described build 16.0.4312.1000 dated 12-Nov-2015. The update we installed resolves the invisible image issue, but we have yet to receive an explanation for the difference.

Microsoft Access 2016Microsoft recently released Office and Access 2016. In our preliminary testing and development with the 2016 version, there’s very little that has changed from Access 2013. However, a bug was introduced late in the development cycle that is quite annoying and serious.

Some Images (Pictures) are Missing

If you’ve added images (pictures) on your forms and reports, they may appear blank in MS Access 2016. For example, here’s a form with a picture image that is blank in 2016:

2016

This occurs with the 32-bit version of Access 2016 (16.0.4229.1024) and not the 64-bit version. That’s not a reason to use the 64-bit version, but it is a difference.

Not All Pictures are Invisible

Some images appear properly, while others don’t. With some research, we discovered:

  1. Images that were originally BMP files appear properly
  2. Graphic types such as GIF, JPG and PNG formats become blank

Impacted by the Picture Property Storage Format Setting

Upon further investigation, the problem is associated with the database’s Picture Property Storage Format when the picture was added to the form or report. This is under the Access Options setting for the Current Database:

Options-PictureFormat

There are two options:

  • Preserve source image format (smaller file size)
  • Convert all picture data to bitmaps (compatible with Access 2003 and earlier)

If the image is added when the option is set to the second option (Convert), the non-BMP graphics do not appear in the 2016 version.

Microsoft is Fixing the Problem

The Microsoft Access team is aware of this bug and fixing it. How long it will take before it’s publicly available is undetermined. It’ll probably be a few months as service packs take a while to get through the Office release process. We’ll let you know when we know.

What to do Now?

If you can’t wait for Microsoft to release a patch and need to use Access 2016 immediately, here’s what you should do:

  1. Set the Current Database, Picture Property Storage Format to “Preserve source image format”
    Options-PictureFormat-preserve
  2. Reinsert your pictures. If your pictures are BMP files, the storage format setting won’t matter

Of course, it’s not easy to find all the places on your forms and reports where this is a problem, then reinsert every picture, especially if you don’t have or can’t find the original graphic files.

Total Access AnalyzerProperty Slices in Total Access Analyzer Can Help

Our Total Access Analyzer program documents all the objects in your database. While it can’t replace your graphic files, it identifies all the places where there’s a picture property. Whether it’s at the object (form or report) level or its controls, the Picture property shows whether an image file is assigned.

After documenting your database, from the Documentation Explorer, click on the Forms folder in the treeview, select the Property Slices tab, then choose the Picture property. This shows every form and its picture property value. The ones that aren’t “(none)” need to be reviewed:

property-slices-forms

Similarly, choose the Controls option and Picture property to see this value for all the controls on all your forms:

property-slices-controls

Press the Design button to put the current row’s form into design mode to make your changes. Then do the same for reports.

Unfortunately, this is quite a hassle for something that should just work. Let us know what you’re experiencing.