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
Add-in Menu to Launch Total Access Detective to Compare Two Objects in the Current Database
The Object Comparison Wizard:
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
FMS 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.
Total Access Analyzer is now available for Microsoft Access 2013 with many new features:
Supports Microsoft Access 2013, 32 and 64-bit versions
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 Total Access Analyzer customers can upgrade for a discounted price.
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)
The Microsoft Access team has released videos of their presentations at the SharePoint Conference from Las Vegas, NV.
With Access 2013, Access web solutions are hosted in SharePoint and rather than using SharePoint lists as they did in Access 2010, they use a real SQL Server database hosted in SQL Azure. The database can also be linked from desktop copies of Access to create hybrid solutions that serve both the web and Windows.
The Microsoft Access program managers presented these four sessions:
Sentinel Visualzer helps analysts mine their data to find hidden relationships among people, places and events. Built with Visual Studio .NET on a SQL Server database, Sentinel Visualizer provdes advanced data visualization through link analysis, geospatial mapping, timelines, social network analysis (SNA), advanced filtering and decluttering, and many other tools to maximize the value of data.
As the rampage and manhunt in Boston, Cambridge, and Watertown transpired, MIT Technology Review published an article that mentioned our Sentinel Visualizer product. In the April 19, 2013 article, David Talbot describes the rise of technology to detect the activities of criminals over the Internet and connect seemingly unrelated people, places and things. For more information, visit Building a Picture of the Boston Marathon Bombing Suspects through Social Network Analysis.
This patch is causing certain programs to break. The Microsoft KB article acknowledges:
We are aware of issues related to OpenType Font (OTF) rendering in applications such as PowerPoint on affected versions of Windows that occur after this security update is applied. We are currently investigating these issues and will take appropriate action to address the known issues.
Well, it impacts more than PowerPoint. If your applications are suddenly experiencing failures, try removing this update to see if it makes a difference. It can be removed from the Control Panel, Add or Remove Programs, under Updates.
When you try to open a database, you may encounter this error message: Could not use [Database Name]; file already in use.
This error occurs if another user (or instance of Access) has opened up the database exclusively and you try to open it. Maybe the other user opened the database in exclusive mode or made some modifications such as editing modules, which put the database in exclusive mode.
However, that may not be the case. This error can occur even if the other user has the database opened without opening it exclusively. What’s going on? Why would the second instance think it’s being opened exclusively?
What if the Other User isn’t Opening it Exclusively?
It turns out that another cause of this error is not immediately obvious and is related to workgroup security files. This applies to MDB files (not ADP or ACCDB formats). If two instances of Microsoft Access (DAO database engine) are using different system MDW files, a conflict may occur where the database appears to be exclusively locked by the other instance. The MDW file used by your instance of Access can be checked in VBA by examining the value of DBEngine.SystemDB.
Another copy of Access or DAO may have that database opened using another MDW file causing this conflict. This can come from another instance of MS Access, a Microsoft Access add-in or library reference, a VBA Add-in, or other program such as VB6, .NET, etc. that’s connecting to that database.
To avoid this, if you’re using workgroup security, make sure every instance is pointing to the same shared MDW file. This is often defined in the shortcut used to launch Microsoft Access, or if you are opening a different database programmatically within your VBA code.
If you’re interested in seeing who’s going in and out of your database in real-time, check out our Total Access Admin program. It’ll let you monitor multiple databases across your network to see when users enter and exit your database and flag instances where connections are dropped suspiciously.
Please join FMS President Luke Chung at the New York Microsoft Access User Group Meeting on September 10, 2012 at 6:30PM.
Luke Chung is the featured presenter at this New York City event hosted at Microsoft Headquarters located at 1290 6th Ave., between 51st and 52nd Streets.
Luke will discuss and demonstrate FMS products for Microsoft Access, Azure cloud computing, plus answer any questions you may have about his experiences. There will also be product giveaways to members of the user group.
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: