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.

Jul 07

Total Access Analyzer Ships for Microsoft Access 2013

Microsoft Access 2013FMS is pleased to announce the release of Total Access Analyzer, version 15, for Microsoft Access 2013. Total Access Analyzer 2013 is our 10th major release of this product since its debut with Access 1.1 in 1993.

Total Access Analyzer 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.

Over 300 Types of Issues are Detected

Total Access Analyzer examines all your database objects in detail to find 300+ types of issues including errors that crash your application, unused objects and VBA code, design inconsistencies, and other best practices to maximize your investment in your Access applications.

390 + Professional Quality Reports

Over 390 filterable and customizable reports are available to document your applications and help you develop more efficiently. Reports include table/field dictionary reports, object cross-reference lists, module printouts, application flow diagrams, field and SQL consistency reports, and much more.

Discover why so many Microsoft Access enthusiasts made Total Access Analyzer the most popular Microsoft Access add-in of all time and the winner of every Best Access Add-in Award for decades.

main-menu-2013[1]

New Features

Total Access Analyzer is now available for Microsoft Access 2013 with many new features:

  • Total Access AnalyzerSupports Microsoft Access 2013, 32 and 64-bit versions
  • New documentation of Conditional Formatting
  • Documentation of Navigation Control and Buttons
  • Documentation of Web Controls
  • New Control Type Reports
  • Support Procedure Calls to Libraries
  • 3 New Module VBA Coding Suggestions
  • Enhanced VBA Module Parser for Compiler Conditionals
  • New Search Bar for Selecting Objects
  • Improved Open Documentation Form
  • Report Filter Shows Count of Issues
  • New Treeview with 64-bit support
  • New user manual and help file
  • and more!

Here’s a complete list of new features.

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

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

May 15

Windows 8.1 PCs Connect to the Network but not the Internet

windows81This past Tuesday night, Microsoft released a security patch. On Wednesday morning, we and some of our customers encountered problems with connectivity that were quite unusual and different from past security updates. The update required servers to reboot which triggered some issues, but manageable. What was particularly troubling were multiple reports of problems with PCs using Windows 8.1.

The PCs could still connect to the network and see all the network resources, but they could not get on the Internet. Using different logins including Administrator logins didn’t make a difference. Other PCs using Windows 7 or older O/S were able to connect successfully even with the same cable as the Windows 8.1 PCs that couldn’t connect.

What Could be Wrong?

We struggled trying to see if there were issues with:

  • Hardware on the PC, network card, cable or switch
  • Software issues with the automatic Windows patches, DHCP network settings, IP addresses, Firewall, antivirus, etc.
  • Login rights and permissions

We couldn’t determine the problem or find a solution. Since the user could log into the network, permissions seemed sufficient.

From the Windows command prompt (Run cmd), we used the ipconfig command with the release and renew command lines to see if that would reset the IP address, but that didn’t make a difference either:

ipconfig /release
ipconfig /renew

Solution: Flush DNS

Finally, I posted a message to the Microsoft Access MVP group, which I’m honored to be a part of. Long time colleague, Tom Wickerath suggested flushing the DNS (Domain Name System) cache by using:

C:\> ipconfig /flushdns

We weren’t familiar with that command line option as it doesn’t appear when you enter

ipconfig ?

Well, it worked! We may never know whether the problem was caused by the Windows security patch or if it was just a coincidence. Regardless, the flushdns command reset the PCs that were affected by this problem.

Thanks for sharing your insight Tom!

Apr 16

Total Access Detective Review by Daniel Pineault

MVPLogo[1]Microsoft Access MVP, Daniel Pineault, wrote a very nice review of our Total Access Detective program recently. Total Access Detective is a Microsoft Access add-in program that finds all the differences between two Access databases or two objects in one database. Changes with table and query structures, field properties, form and report controls and properties, macros, module VBA procedures and lines of code, and even data are detected.

Daniel found Total Access Detective very helpful when confronted with the challenge of determining exactly what changed between two Microsoft Access databases. Rather than manually and tediously trying to determine what changed, he used Total Access Detective to quickly generate a comprehensive comparison to find objects in one database and not the other, and a detailed comparison of objects with the same name. With Total Access Detective, he was able to pinpoint all the differences and make the necessary adjustments.

We were pleased he concluded with this:

Microsoft Access Difference DetectorFinal Verdict
“I am once again quite confident in putting my stamp of approval on this tool. If you are in a situation in which you quickly need to identify all the differences between multiple databases, FMS’ Total Access Detective will make short work of the job at hand! …
A very nice, easy to use and most importantly, effective and thorough tool!”

To learn more about what Daniel discovered and his experience, read his article:  Total Access Detective – Review

Thanks Daniel!

Feb 13

New Microsoft Access to SQL Server Upsizing Resource Center

Microsoft Access to SQL Server Upsizing CenterWe’ve completely revamped our Microsoft Access to SQL Server Upsizing Resource Center. Find links to all our related white papers and Microsoft resources to help you with the SQL Server upsizing process, from deciding why and which Microsoft Access databases to upsize, the different options, and using SQL Server Express.

We have several new and updated resources:

  • Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads
    For the first time, all the different versions of SQL Server Express from 2005 to 2014 are shown, compared, and referenced with download links. This content required extensive research to document the details of which operating system each SQL Server version supports. Just because Microsoft web pages list the versions they support doesn’t necessarily mean it works when you actually try to install it.
  • Automating the Backup of Your Microsoft SQL Server Express Databases
    If you’re using SQL Server Express, you still need to create backups of the database. Here’s how to automate it.
  • When and How to Upsize Microsoft Access Databases to SQL Server
    The original version of this was written for Microsoft when they selected us for a joint national campaign a decade ago to promote Microsoft Access to SQL Server Upsizing. We’ve updated it to better explain why and why not people should upsize their Access databases and an overview of what the options are and what to do.

Hope this helps!