Category Archives: Microsoft Access

Dec 20

Total Access Analyzer 2019 is Shipping

Posted on by

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.

Oct 09

Microsoft Access has detected that this database is in an inconsistent state

Posted on by

Recently, Microsoft Access users are confronted with this error when they open their database on Windows 10 machines:

“Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the ‘Recovery Errors’ table.”

‘inconsistent state’, Error 3343 “unrecognized database format

This seems to be related to Microsoft security updates that were released over the past few months.Our investigations lead us to these two links:

Microsoft Explanation

Microsoft discusses this problem here: Microsoft Access reports that databases are in an ‘inconsistent state’

Workaround

A potential workaround suggests to ensure that SMBv2 or SMBv3 is enabled on both client and server, as described in this Knowledge Base article:
How to detect, enable and disable SMBv1, SMBv2, and SMBv3 in Windows and Windows Server

We hope you find this helpful. Let us know your experience with this.

Aug 27

Total Access Emailer Update for Microsoft Access 2016

Posted on by

Total Access Emailer is the most popular email automation system for Microsoft Access. A new update was released for the Microsoft Access 2016 version.

Enhancements

  • Partially Restored Original SMTP ValidationTechnique.
  • Validation of FROM Address during Email Blasts.
  • Adjusted the saving of datasheet column settings on databases before Access 2007.
  • Improved Offline activation and uninstall.
  • Cosmetic changes to the program and sample databases.

For more information, visit:

Existing Total Access Emailer 2016 owners were notified to download the update.

Jun 27

Total Access Emailer Update for Microsoft Access 2016

Posted on by

Total Access Emailer is the most popular email automation system for Microsoft Access. Update 16.01.0014 was released for the Microsoft Access 2016 version.

Enhancements

  • SMTP validation uses your email address and eliminates the need to use a TEmail.txt file.
  • Changes you make in the datasheets settings such as column settings, sort order, and/or filters are saved where appropriate for the next time the form is opened.
  • Preview Text allows you to test your email blasts by sending the emails to your own email address.
  • When creating an email blast, the FROM email address is validated for an acceptable email format.
  • When the name of an attachment file includes invalid characters (e.g. :*?”<>|), a message indicates that problem rather than saying the file can’t be found.
  • Procedure TotalAccessEmailer_SendOne has two parameters (strMessageHTML and strHTMLFile) that are optional but were previously required.
  • Sample database updated with TLS option and larger fonts.
  • Cosmetic changes to increase font size, widen combo boxes, font consistency, and support for higher resolution monitors.
  • Manual and help file updated.

The latest update for Total Access Emailer 2016, Version 16.0 is:

Existing Total Access Emailer 2016 owners were notified to download the update.

May 19

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

Posted on by

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

Apr 23

Microsoft Azure SQL Server Usage and DTU Limit Resource Graphs are Confusing

Posted on by

microsoft-azure-h60 SQLServerText

Microsoft Azure lets you easily create and deploy enterprise quality SQL Server on the cloud and scale it to suit your application’s needs. From the SQL Server database’s Azure dashboard, you can see the Database Transaction Unit (DTU) usage against the specified DTU limit for the database.

One Hour Usage Graph

This is what we saw for usage over one hour. The cyan line across the top is the DTU limit. The dark blue line is the DTU used. The limit is what you pay, so it’s important to scale it to what the application needs.

monitor-hour

One Hour Azure SQL Server DTU use versus limit

While everything seemed fine at the weekly level, looking at the hourly graph gave us a shock. It looks like the database is maxed out for most of the hour. It seems conclusive that we need to increase our DTU level.

65 Minute Graph

But when we set the range to 65 minutes and saw this:

monitor-65-minute

65-minute Azure SQL Server DTU use versus limit

These are completely different displays of the same period of time. The 65 minute graph never hits the maximum DTU. What’s going on?

Visit our page Monitoring SQL Server Usage on Microsoft Azure and Setting DTU Limits for an explanation.

Mar 20

Microsoft Access/Office Resources

Posted on by

There are many online Microsoft Access resources available from the Access and Office teams.

New Microsoft Access Tech Community Site

access-community

This is the Microsoft Access development team’s community site that’s integrated with the Access program. Expect to see more and more information and discussions here:

Microsoft Access Tech Community Site

Online Microsoft Access/Office Training

office-training

Online training videos from Microsoft are available for most Office products.

Online Microsoft Office Training

Click on the Access icon to see the Microsoft Access training videos, or go directly to:

Microsoft Access Training Videos

Microsoft Access Help Center

access-helpcenter

The documentation team manages this site for MS Access documents and online help.

Microsoft Access Help Center

Old Microsoft Access Support Team Blog

access-blog

This Microsoft Access blog site is being retired but still has relevant information.

Become an Office Insider

office-insider

If you have an Office 365 subscription, and want to get the latest builds of Office/Access, become an Office Insider.

Sign up from the PC that will host the insider version. Of course the insider version is not ready for prime-time, so don’t use it for your development or production environment.

Office Insider Sign-up

Feb 21

Microsoft Access Version Comparison Matrix

Posted on by

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

Posted on by

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.

Nov 28

Microsoft Access is 25 Years Old!

Posted on by

birthday25Microsoft Access is celebrating its 25th year this month. It’s an amazing accomplishment for a software product to be so successful for so many years. We at FMS were there since the beginning.

Read our first hand, historical account of watching Microsoft Access take over the Windows desktop database market, and how we became the world’s leading 3rd party developer of Microsoft Access products.

Discover how we watched MS Access rise from nothing to the leading Windows desktop database application. This directly caused the implosion of Borland International which previously dominated the desktop database industry. Witnessing this in person was an amazing experience of how quickly technology can change established, large software businesses.

This article was originally published by Microsoft on their website for the 10 Year Anniversary Celebration of Access (October 2002).

The video is from the November 1992 COMDEX conference where a very young Bill Gates personally announced the debut of Microsoft Access. He remains a big fan of Access and was actively involved in its design and development.
bill-gates