Recent News from FMS

Visit our FMS Development Team BlogBlog and Facebook for Microsoft Access Products from FMS Facebook page for our latest news.

Washington DC Access User GroupSeptember 19, 2018

7:00PM - 9:00PM

Microsoft Store in Tysons Corner Center

Join FMS President Luke Chung on September 19, 2018, at the Washington, DC Access User's Quarterly Group meeting at the Microsoft Store in Tysons Corner Center.

Tammy Lawson will be giving a presentation on Integrating Microsoft Access with PowerBI to create visualizations.

For more information, visit Washington, DC Microsoft Access Meetup.

Microsoft Most Valuable Professional

Microsoft recognized FMS President Luke Chung as a Microsoft MVP for the seventh year in a row for his support in the Microsoft Access community!

The Microsoft Most Valuable Professional (MVP) award is given to individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.

Microsoft Most Valuable Professional

FMS Newsletter

Our August newsletter is now available!

If you did not receive the newsletter through email, you will find it here:

FMS August 2018 Newsletter

Total Access Analyzer 2016
See What's Really Going on Inside Your Access Databases!

Microsoft Access 2016 Database Documenter


Total Access Emailer 2016
Send Personalized Emails from Microsoft Access!

Microsoft Access Email Blaster


Microsoft Access to SQL Server Upsizing

Updated Microsoft Access to SQL Server Upsizing Center with whitepapers, resources, and SQL Server Express Downloads

Total Access Emailer

August 21, 2018

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 Validation Technique.
  • 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.

July 19, 2018

President Lincoln's Cottage, Washington, DC

FMS President Luke Chung was honored to meet David Rubenstein, philanthropist and co-founder of the Carlyle Group during the Washington DC Chapter of the Entrepreneurs Organization event.

The event was held at President Lincoln’s Cottage in Washington, DC, where Lincoln summered and drafted the Emancipation Proclamation, two copies of which David purchased and donated. David Rubenstein is a fascinating and inspirational leader who has helped many companies around the world, and is dedicated to a legacy of preserving historic documents and sites, and pandas.

David Rubenstein

FMS Newsletter

Our July newsletter is now available!

If you did not receive the newsletter through email, you will find it here:

FMS July 2018 Newsletter

Washington DC Access User GroupJuly 18, 2018

7:00PM - 9:00PM

Microsoft Store in Tysons Corner Center

Join FMS President Luke Chung on July 18, 2018, at the Washington, DC Access 2nd Quarter User's Group meeting at the Microsoft Store in Tysons Corner Center.

Members will share their experiences with Microsoft Access and the solutions to different Microsoft Access questions.

For more information, visit Washington, DC Microsoft Access Meetup.

Microsoft Most Valuable ProfessionalJuly 1, 2018

Microsoft has officially recognized FMS President Luke Chung as a Microsoft MVP for the seventh year in a row!

Visit Microsoft's MVP Public Profile Page to learn more about Luke's contributions to the Microsoft Access Community.

Congratulations Luke!

Total Access Emailer

June 19, 2018

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

  • 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 setting 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 had 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.

For more information, visit:

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

Total Access Detective

May 18, 2018

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

FMS Newsletter

Our May newsletter is now available!

If you did not receive the newsletter through email, you will find it here:

FMS May 2018 Newsletter

May 11, 2018

Remote Desktops connections are failing to connect due to a security patch that was released on May 8, 2018.

Remote Desktop Connection Error

An authentication error has occurred.
The function requested is not supported

Remote computer: [computer name]
This could be due to CredSSP encryption oracle remediation.
For more information, see https:/go.microsoft.com/fwlink/?linkid=866660

It's also impacting VPN connections.

We wrote a blog post on the issue, symptoms, causes, and workaround. This is a brand new situation. Please share your experiences.

Microsoft Azure and SQL Server

FMS President Luke Chung wrote step by step instructions on how to convert existing databases to an Elastic Pool.

Microsoft provides information on Elastic Pools but does not give you information on how to convert existing databases to those Elastic Pools.

Configure Azure SQL Elastic Pool

Visit our page Converting Microsoft Azure SQL Server Databases to SQL Elastic Pools to Share Server Resources for more information.

Portland Oregon Microsoft Access User ConferenceApril 28 - 30, 2018, Silver Falls State Park, Oregon

The Portland Access User Group held their annual event at the conference center in the beautiful Silver Falls State Park a few hours south of Portland, Oregon. The weekend event brought together some of the top Microsoft Access developers, enthusiasts, and Access development team members.

FMS President Luke Chung was one of the featured speakers. He made two presentations:

  • Data Analytics: Query Tips and VBA Code
  • Form and Report Design Tips and Techniques

2018 Portland Access User Group

FMS Newsletter

Our April newsletter is now available!

If you did not receive the newsletter through email, you will find it here:

FMS April 2018 Newsletter

Microsoft Azure and SQL Server

FMS President Luke Chung wrote a new paper on monitoring SQL server usage and setting DTU Limits with Microsoft Azure.

Why does the 60 minutes graph look so different from the 65 minutes graph?

Monitoring SQL Server Resources in Microsoft Azure
60 Minute Graph

Microsoft Azure SQL Server Database use over the past 65 minutes
65 Minute Graph

To learn why, visit: Monitoring SQL Server Usage on Microsoft Azure and Setting DTU Limits

Access DevCon in Vienna, AustriaApril 7-8, 2018, Hotel Strudlhof

FMS was a sponsor for the second Microsoft Access Developer Conference in Vienna, Austria.

Fellow Microsoft Access MVP Karl Donaubauer hosted a sold-out event with 60 attendees from 13 countries. Photos from the 2018 event are available here.

FMS President Luke Chung was a featured speaker for the 2018 conference and gave a new presentation on Incompatibilities Among Microsoft Access Versions

For more information: Access DevCon Vienna

Luke Chung at the 2018 Access DevCon in Vienna Austria

Facebook App for Social Network Analysis

April 11, 2018

The Facebook security breech is actually a violation of Facebook API licensing rules. Facebook provided the data so developers like us could create innovative solutions. They weren't selling the data.

One of the things developers couldn't do was to save the data. That's how the data improperly got to Cambridge Analytica. All of that was shut down shortly when Facebook limited their APIs and prevented our application from getting to the data. It's not entirely Facebook's fault for trying to spur innovation by sharing their data for free. Unfortunately, some developers violated their terms completely.

Here’s a new web page describing our experience in more detail: Facebook Application with Social Network Analysis (SNA) and Geospatial Mapping

Facebook App with Social Network Analysis and maps of your friends

For more information, visit our blog post:

What happened when we created a Facebook App for Social Network Analysis

March 20, 2018

FMS President Luke Chung had the pleasure to attend a meeting with Linda McMahon the SBA Administrator. Linda McMahon spoke about the Small Business Administration that she currently leads, how they help businesses around the country, and her journey from a small town in NC to running the WWF, now WWE, in an obviously male dominated industry.

Small Business Administration

Microsoft Access

Here's a list of free resources directly from the Microsoft Access team. It includes the new technical community, training videos, help center, blog, and how to sign up to be an Office Insider.

Visit our blog post for more details.

Microsoft Access/Office Resources

FMS Newsletter

Our March newsletter is now available!

If you did not receive the newsletter through email, you will find it here:

FMS March 2018 Newsletter

Access Day 2018FMS President Luke Chung gave a presentation on Microsoft Access Form Tips and Techniques to a group of Access enthusiasts at Access Day in Redmond, Washington.

Access Day 2018

Microsoft MVPCelebrating Microsoft Access with fellow Access MVPs at the annual Microsoft MVP Summit. Pleased to learn of the new features coming to the Access Desktop in Office 2019, and the positive direction the Access development team is taking.

Microsoft MVP Summit

Towson University

March 14, 2018, Towson University

2018 Microsoft MVP Tech Tour at Towson University.

FMS President Luke Chung is a speaker and will

  • Present Cloud Technology: Office Desktop (Access/Excel) to SQL Server to the Azure Cloud
  • Participate on a Career Panel Discussion
Microsoft Access Version Comparison Matrix

Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, and discontinued features.

It's hard to remember all the changes. Fortunately, we created a page that shows the different Microsoft Access versions and changes in an easy to understand comparison matrix. 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.

Microsoft Access Version Features and Differences Comparison Matrix

Access Day in Redmond, Washington

March 8, 2018, Redmond, Washington

Join us for Access Day, the one-day event with a variety of expert speakers and topics.

FMS President Luke Chung is a presenter and will be discussing Microsoft Access Form Tips and Techniques.

For more information and registration, visit: 2018 Access Day

Microsoft Access Updates and PatchesFebruary 2, 2018

We’ve updated our list of Microsoft Access updates and patches to includes Microsoft’s recent releases for MS Access 2016 and 2013.

It also includes information on the three different update channels for Office 365 and how that compares to the perpetual Office/Access license.

Links to the Microsoft KnowledgeBase articles and download files are included.

FBI Missing Text MessagesThe Sean Hannity Radio Show, January 22, 2018

Background

On January 22, 2018, Luke Chung was on the radio show with Sean Hannity and Andrew Ziem. The three of them discussed the technology behind the ability to retrieve text messages that were deleted. Luke commented specifically on:

  • How text messages are stored on a sender’s/receiver’s device, unlike emails which are stored on a central server.
  • The ability to retrieve an email that has been deleted is more likely than trying to retrieve a text.

To listen to the interview and more insight on these issues, visit Luke Chung's blog post:

Sean Hannity Radio Show Interview on Missing FBI Text Messages

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

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

Enhancements:

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

Microsoft Access Email Add-in ProgramTotal Access Emailer is a Microsoft Access program that lets you send personalized emails with attachments from your tables and reports to everyone on your list. The Professional Version includes the Access add-in and a VBA Library so you can launch email blasts from VBA code and events.

We've created a new support page to help troubleshoot common issues when using the VBA interface.

  1. Make sure your copy of Total Access Emailer supports your Access version.
  2. If you upgrade your database from an MDB to ACCDB format, be sure to also update your Total Access Emailer library reference from our MDE to ACCDE library file.

Microsoft Access 25th Birthday AnniversaryMicrosoft Access is celebrating its 25th year. 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 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 at Comdex 1992

Microsoft Access QueriesRead our new paper on how to easily convert a field's text to Proper Case (or ALL CAPITALS or all lower case). This can be done with a Microsoft Access query without having to write any VBA code.

By using VBA StrConv function in an Update Query, one can convert the value of a field into Proper Case and update a field with it:

Update Query with StrConv to Change to Proper Case

For more details, including a sample database, read our new paper: Microsoft Access Query Tip to Convert a Text Field to Proper Case

September 11, 2017, 6:30 PM

Microsoft Headquarters, New York City

FMS President Luke Chung is the featured presenter at the Microsoft Access User Group meeting in New York City.

Watch him share his experiences and demonstrate FMS products for Microsoft Access, SQL Server, Azure cloud computing, and techniques to improve your productivity.

Microsoft Access Email Add-in ProgramAugust 11, 2017

Total Access Emailer is the most popular email program for Microsoft Access.

We've created new articles for Total Access Emailer to work with SMTP servers from Microsoft Office365 and Google Gmail:

Find exactly what is different between Microsoft Access databases, objects, code, and dataJuly 21, 2017

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

Enhancements:

  • 2016 Version: Support for the new update of Access 2016 in May 2017
  • 2016, 2013, 2010 Versions: Comparison of Data Macros in ACCDB databases
  • Two database comparison, Object Selection screen enhancements highlight objects with different modification dates and filtering
  • If you resize datasheet columns while viewing the Total Access Detective results, your column widths are preserved the next time you reopen the form
  • Improved user interface with increased font sizes
  • Automatic selection of A4 paper size for international users
  • More trapping of Access database errors
  • New user manual and help file
  • and more...

For more information, visit:

This is a free upgrade for people on a support contract and owners of the 2016, 2010, and 2007 versions. Existing Total Access Detective 2013 customers can upgrade at a discounted price.

FMS President Luke Chung was a presenter at the Microsoft Access DevCon 2017 in Vienna, Austria in early April.

Before giving two conference presentations, he was sat down and spoke with Philipp Stiefel of codekabinett.com of Germany discussing VBA development.

They talked about:

  • VBA Best Practices
  • How end-users migrate from Excel to Access, then learn how to code
  • Why people are hesitant to purchase third party products and how FMS overcomes that by showcasing the value we offer
  • Using tools like Total Access Analyzer to catch errors before shipping and learning best practices
  • Using the module code in Total Visual SourceBook to address problems we've already solved so you can focus on the unique issues in your applications
  • The value of creating consistent, quality code How to improve code for developers of all backgrounds
  • Being in constant "growth" mode to look for ways to become a better developer

Access DevCon in Vienna, AustriaApril 1-2, 2017, Hotel Strudlhof

FMS friend and Microsoft Access MVP Karl Donaubauer is organizing a Microsoft Access conference in his hometown of Vienna, Austria the weekend of April 1-2, 2017. Please let him know if you are interested in attending. He has organized many Access conferences in Germany. This is the first in English.

FMS President Luke Chung is a featured speaker and will discuss Microsoft Access Strategies and Products. Many of the world's leading Microsoft Access developers will be speaking with Luke. Visit the agenda to learn more.

Arrive a day early for a free guided tour of the beautiful and historic city of Vienna, a UNESCO World Heritage site.

For more information and registration, visit: Access DevCon Vienna

January 9, 2017

Build 16.00.0015 was released and is available for free to all Total Visual Agent 2016 customers. For more information on the update, visit Enhancements in Total Visual Agent 2016, Build 16.00.0015

The Total Visual Agent Version and Updates page was also enhanced to show the history of the product since its debut 20 years ago

The Sean Hannity Radio Show, January 4, 2017

Sean Hannity Radio ShowBackground

The day after an amazing personal interview of Julian Assange by Sean Hannity aired on his TV show, FMS President Luke Chung was invited to discuss the related technology on his radio show.

Hannity traveled to London to interview Assange at the Ecuadorian Embassy where he’s seeking asylum. They discussed an overview of Assange’s role as founder of WikiLeaks, and their obtaining and publishing the emails from the Democratic National Committee the weeks before the US Presidential election. Some people attribute Hillary Clinton’s loss to the revelations in those emails especially from John Podesta, the former White House Chief of Staff and Chairman of the Clinton campaign. They are also accusing the Russians for hacking (stealing) and providing the data to Assange so Donald Trump could win the election.

Radio Show

On January 4, 2017, Luke was on the radio show with Sean Hannity and Brigadier General Eli Ben Meir, former Israeli Military Intelligence chief. The three of them discussed the WikiLeaks disclosures. Luke commented specifically on:

  • Cyber attacks and the security breach at OPM disclosed non-classified government employees and by omission who were covert at American Embassies globally.
  • Noting Julian Assange’s careful word choices to exclude Russia as source without excluding them as the ultimate source of his sources.
  • The need for WikiLeaks’ to keep their sources confidential and how they amplified the data from Bradley Manning and Edward Snowden.
  • Different approaches to preventing cyber attacks depending on the cause.

“It’s one thing when someone steals your car because they broke into it. It’s another thing when someone steals your car because you left your keys in the ignition.”

To listen to the interview and more insight on these issues, visit Luke Chung's blog post:
Sean Hannity Radio Show Interview on Julian Assange, WikiLeaks, Russian Hacking, and Cyber Warfare

Monitor Microsoft Access Databases in Real TimeDecember 21, 2016

Total Access Admin lets you monitor users going in and out of your databases in real-time. See who's currently in your database and who recently exited, create a log of connections and disconnects, compact the database after everyone exits, etc. Monitor all the databases across your network from one installation of Total Access Admin.

Total Access Admin 2016 includes many new features.

  • Does not require Microsoft Access to be installed on your machine
  • Works in environments where either Access 32 or 64-bit versions is installed, including installations from Microsoft Office365
  • Up to 150 databases can be monitored at one time (up from 100)
  • Setup program supports Windows 8 and 10, and has an option to launch the program after its installed

Read our New Features page for details.

Download the free trial version of Total Access Admin to monitor Microsoft Access databasesDownload the free, fully-functional Trial Version to see how helpful Total Access Admin can be for you. Existing customers can upgrade at a discounted price.

Microsoft Access Statistical AnalysisNovember 30, 2016

A new version of Total Access Statistics is now available for Microsoft Access 2010 (32 and 64-bit versions).

Running as an Access add-in Wizard, Total Access Statistics generates a wide range of numerical analysis beyond the power of queries. All results are in Access tables that you can add to your queries, forms and reports.

The new 14.1 version is an update from version 14.0 which was released in 2010 and includes many new features:

  • Compatibility with the latest versions of Windows and runtime library
  • The VBA runtime libraries in the Professional Version are upgraded so you can support users running your application in Access 2013 and 2016.
  • Additional Percentile Types can be assigned to a field in your table
  • Data formatting enhanced
  • Performance improvements
  • Improved financial calculations
  • Updated User Manual and Help File

Here's more information on Total Access Statistics 14.1 Enhancements.

Download the free trial version of Total Access Statistics for Microsoft Access data analysisThe Free Trial was updated so you can experience it yourself.

Existing Total Access Statistics owners can upgrade at a discounted price.

Microsoft Access Database LauncherSeptember 26, 2016

We released update 16.00.0030 for Total Access Startup 2016 to address a few issues:

  • Special Handling for Autoexec Macros
  • Run the Administrator Program on Machines without Microsoft Access Installed
  • User Manual and Help File Updated

For more information, visit our Total Access Startup 2016 update page. Existing customers were notified via email for the free update.

Total Access Startup lets you centrally manage the deployment of Access applications for each user. Download the Free Trial to experience it yourself.

Microsoft Access DocumenterSeptember 7, 2016

Total Access Analyzer, the most popular Microsoft Access add-in, 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, and increases your productivity.

Build 32 was released with enhancements and fixes listed by version:

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

Microsoft Access SchedulerAugust 24, 2016

Total Visual Agent, the world's most popular maintenance scheduling tool for Microsoft Access/Office and Visual Basic 6 (VB6) is now available for Microsoft Access 2016 (and earlier). This is the ninth major release of Total Visual Agent and introduces many enhancements to automate maintenance chores easier than ever.

To keep your Microsoft Access databases healthy, you need to regularly compact them. For disaster recovery, you should also be making backup copies of your database regularly. You may also have regular tasks such as printing reports that are performed regularly. Total Visual Agent does this and much more on a schedule you specify. Run tasks hourly, daily, weekly, monthly or just one time. Perform database chores, run Access macros or Windows command lines.

A complete audit trail is maintained, and you can even be notified by email if something goes wrong. Total Visual Agent can also be run as a Windows service to restart if the machine reboots and for added security since a user doesn't need to be logged in.

Total Visual Agent 2016 leverages our vast expertise, and offers the best database management solution with many new features:

  • Supports Microsoft Access 2016
  • Supports Windows 8 and 10
  • Does Not Require Access to be Installed on your PC
  • Database Lock Error Identifies Offending Machines
  • Activity Log is Separated from Settings Database
  • Activity Log Shows Duration of Each Activity
  • Email Notifications Support TLS and Office365 SMTP
  • Tasks are Not Run at the End of an Event
  • Interval Enabled/Disabled Status Shown on the Event Form
  • More Robust Windows Service Feature
  • Improved Monitor Settings Tab
  • Default Location of Archive and Extract Folders Moved
  • Improved Setup Program
  • New user manual and help file
  • and More...

Download the free trial version of Total Visual Agent to automate Microsoft Access database choresDownload the Free Trial to experience it yourself.

Existing Total Visual Agent owners can upgrade at a discounted price.

Microsoft Access Email Add-inAugust 15, 2016

With the release of Total Access Emailer for Microsoft Access 2016, we've released updates for versions for Access 2013, 2010, and 2007:

  • Version 15.7 for Access 2013
  • Version 14.7 for Access 2010
  • Version 12.7 for Access 2007

Existing customers with a current priority support agreement receive free upgrades. Customers without a support contract can upgrade for a nominal fee.

Running as an Access add-in Wizard, Total Access Emailer lets you send personalized emails to everyone in your table or query. Easily customize messages using fields in your data source, attach files on disk, and add Access reports as PDF files that can be filtered for each recipient.

A variety of new features are added to the X.7 version:

  • Validate the Email Addresses in Your Email Blast Before Sending It
  • Save Attachment Files to Disk in Addition to or Instead of Emailing
  • Updated Documentation
  • Support for Office365 and other SMTP Services using TLS

For more details, visit the New Total Access Emailer X.7 Features page

Download the free trial version of Total Access Emailer to send emails from Microsoft AccessDownload the Free Trial to experience it yourself.

Existing Total Access Emailer owners can upgrade at a discounted price.

Microsoft Exchange Server on Office365June 30, 2016

A few years ago, we migrated our email service to Microsoft's Office365 cloud service. Overall, it's been very reliable and eliminated the challenges we had hosting Exchange ourselves. It let us get to our emails using Outlook installed on Windows, any internet browser, and smartphones. Office365 also offered other Office product online (Access Web Apps, Excel, Word, etc.), SharePoint and OneDrive Business.

Unfortunately, on the morning of June 30th, we discovered:

  • Microsoft OutlookDelays sending and receiving emails Some emails were bouncing back from recipients who couldn't validate our Office365 Exchange Server's SMTP (protection.outlook.com) with our domain name.
  • That meant the Exchange SMTP server was no longer considered a trusted sender of emails from the @fmsinc.com domain.
  • Our use of the Office365 SMTP server to send emails with our Total Access Emailer product was also failing to authenticate against the server

Needless to say, we aren’t happy about this experience which has impact us, our clients using Office365, and Office365 customers around the country.

FMS BlogFor more information, including Microsoft's response, read our new blog post:
Microsoft Office365 Exchange Server Performance Degradation and SMTP Problems

Microsoft Access Email Add-inJune 13, 2016

Total Access Emailer, the most popular email program for Microsoft Access, is now available for Access 2016 (32 and 64-bit versions).

Running as an Access add-in Wizard, Total Access Emailer lets you send personalized emails to everyone in your table or query. Easily customize messages using fields in your data source, attach files on disk, and add Access reports as PDF files that can be filtered for each recipient.

A variety of new features are added to the Microsoft Access 2016 version:

  • Validate the Email Addresses in Your Email Blast Before Sending It
  • Save Attachment Files to Disk
  • Preview Saving Files to Disk
  • New VBA Function to Preview Email Blasts with Files
  • Code Generator Supports Preview Email with Save Folder
  • Updated Documentation
  • Support for Office365 and other SMTP Services using TLS

For more details, visit the New Total Access Emailer Features page

Download the free trial version of Total Access Emailer to send emails from Microsoft AccessDownload the Free Trial to experience it yourself.

Existing Total Access Emailer owners can upgrade at a discounted price.

Microsoft Access Statistical AnalysisMay 4, 2016

Total Access Statistics is now available for Microsoft Access 2016 (32 and 64-bit versions). Running as an Access add-in Wizard, Total Access Statistics generates a wide range of numerical analysis beyond the power of queries. All results are in Access tables that you can add to your queries, forms and reports.

Total Access Statistics includes a VBA programmatic interface with a royalty-free runtime distribution library so you can add the advanced analysis into your Access applications for distribution to others.

Download the free trial version of Total Access Statistics to Microsoft Access data analysisDownload the Free Trial to experience it yourself.

Existing Total Access Statistics owners can upgrade at a discounted price.

Microsoft Access Database LauncherApril 11, 2016

We are delighted to announce new versions of Total Access Startup for Microsoft Access 2016 and 2013. Total Access Startup makes it easy to deploy the latest version of your Access database to each user's desktop and launch it with the right version of Access.

Many new features were added:

  • Support for Microsoft Access 2016 and 2013 while specifying bitness: 32-bit, 64-bit or both
  • Optionally specify a specific range of allowable Microsoft Access versions
  • New tabbed Administrator Wizard interface to simplify setting the options
  • Ability to add a graphic file for a professional splash screen as the program loads (including replacing the Access splash screen)
  • Add an icon to the distributed shortcut from our library of 1,150+ icons
  • Customize and localize any of the user messages to your own words and language
  • New manual and help file
  • For additional details, visit New Features in Total Access Startup 2016

Download the free trial version of Total Access Startup to manage Microsoft Access version launchingDownload the Free Trial to experience it yourself.

Existing Total Access Startup customers can upgrade at a discounted price.

Microsoft Access 2010

March 9, 2016

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

FMS President Luke Chung wrote this blog post to describe the cause of the problem, and the impact it has on Access wizards and databases people create. Information is also provided with illustrated step-by-step screenshots to uninstall the update.

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

March 7, 2016

Learn how to setup Windows Remote Desktop Connections so you can run other PCs from your machine. Whether it's another PC on your desk, across the hall or another site, Remote Desktop lets you run other machines without leaving your chair. This new paper covers how to configure a PC to allow this, troubleshoot some of the common problems and enable your connection to take advantage of multiple monitors.

Multiple Display Monitors

New Paper: Tips and Techniques for Setting Up Remote Desktop Connections and Using Multiple Displays

Find exactly what is different between Microsoft Access databases, objects, code, and dataJanuary 7, 2016

We are delighted to announce new versions of Total Access Detective for Microsoft Access 2010 and 2007.

In conjunction with the release of Total Access Detective for Access 2016, we've added many of the new features for the 2010 and 2007 versions to help you pinpoint differences between your Access databases and objects.

For details, visit:

This is a free upgrade for people on a support contract. Other existing Total Access Detective customers can upgrade at a discounted price.

December 14, 2015

FMS President Luke Chung participated in a live studio interview with Greta Van Susteren on her evening show, On the Record. Discussing the tragic San Bernardino, CA terrorist incident, Greta questioned how the State Department could have allowed the terrorists to enter the country. Luke confirmed how Google and Twitter searches can be used to screen immigrants, along with the challenges of tracking people intent on hiding their identities and activities with multiple aliases.

Luke Chung, FMS President, on Greta Van Susteren
Luke Chung and Greta Van Susteren
Luke Chung, Tech Expert

FMS has experience with law enforcement and counter-terrorism through our Sentinel Visualizer data visualization program that helps analysts find hidden relationships among people, places, and events. (more media)

FMS Email Newsletter

If you don't get our newsletter emailed to you, here it is:

FMS December 2015 Newsletter

December 18, 2015

Find exactly what is different between Microsoft Access databases, objects, code, and dataWe are delighted to announce the release of Total Access Detective for Microsoft Access 2016 and 2013. 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.

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: Total Access Detective 2016 and 2013

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

Microsoft Access 2013 DocumenterDecember 2015

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, and increases your productivity.

Total Access Analyzer 2016 includes many new features to help Microsoft Access developers create better solutions:

  • 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. Existing customers can upgrade at a discounted price. A demo version is available.

Common spelling errors on Microsoft Access forms and reportsDecember 2015

Total Access Speller helps you avoid typos on the screens your users see. Spell check labels, captions, validation text, status bar, navigation bar, and other properties to avoid embarrassing mistakes. It is now available for Microsoft Access 2016. A free trial is also available.

Common spelling errors on Microsoft Access forms and reports

Microsoft Access ProductsOctober 21, 2015

Microsoft Office 2016 was recently released. For the most part, Microsoft Access 2016 didn't change much. Unfortunately, it includes a serious bug that makes it challenging to adopt it.

Picture images on forms and reports (which work in MS Access 2013 and earlier) appear blank in the 32-bit version of MS Access 2016.

Microsoft Access 2016 Invisible Picture Image on Forms and Reports

FMS Development Team BlogLearn more about the issues and solutions in this blog post: Microsoft Access 2016 and Invisible Picture Images

October 10, 2015

We've redesigned our website with a new home page, menu system, search, and other features to make our site more appealing, more functional, and easier to navigate.

Microsoft Windows Azure
Microsoft SQL Azure

It's now hosted by the Microsoft Azure cloud with a SQL Azure database.

We hope you like the new design.

Microsoft Access DocumenterAugust 2015

In conjunction with the release of Total Access Analyzer for Microsoft Access 2013, we've created updates for earlier versions of MS Access:

Click on the links for detailed information on the new features. Customers on an annual support contract receive the new versions for free. Other customers can purchase an upgrade.

Learn more about the updates in this blog post: Total Access Analyzer 2010, 2007 and 2003 Updates Ships

FOX Business NewsJuly 29, 2015, Neil Cavuto's Coast-to-Coast Show

FMS President Luke Chung had a live interview on July 29 with Neil Cavuto on his FOX Business News show Coast-to-Coast. Luke chatted about text and email technology related to NFL Quarterback Tom Brady's destruction of his smartphone. Unfortunately, Fox did not release an online copy of the interview, so we can't share it. Read more information in Luke's blog about the experience: Appearance on FOX Business News for Tom Brady's Destroyed Text Messages.

Luke Chung, Computer IT Expert
Luke Chung and Neil Cavuto
Luke Chung, FMS President

Microsoft Access DocumenterJuly 6, 2015

The most popular Microsoft Access add-in of all time, Total Access Analyzer provides detailed documentation and analysis of MS Access databases to help you better understand how your objects work together and 300+ ways to detect errors, find unused objects and VBA code, improve performance, and conform to best practices.

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

  • Supports 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
  • Updated user manual and help file
  • and more!

Here's a complete list of New Features.

For more information on the the new Total Access Analyzer read our blog post: Total Access Analyzer Ships for Microsoft Access 2013.

Monitor Microsoft Access Databases in Real TimeJune 1, 2015

With all the new features added to Total Access Admin 2013 in April, an updated version 11.6 for Access 2003 was released.

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.

The new version replaces version 11.5 and includes many new features:

  • Translates obscure computer names to a more understandable user name from a list you maintain.
  • Enhances the activity log database to include user names.
  • Increases the maximum number of databases that can be simultaneously monitored from 50 to 100.
  • Supports specifying a time for the program to quit (exit).
  • Adds new command line parameters to specify the hours and seconds to wait before quitting.
  • Adds setup options to install for the current user or machine to support User Access Control rights as established by your Windows login.
  • Includes a new user manual and help file.

Visit our New Features page for details.

Monitor Microsoft Access Databases in Real TimeApril 22, 2015

Total Access Admin lets you monitor users going in and out of your databases in real-time. See who's currently in your database and who recently exited, create a log of connections and disconnects, compact the database after everyone exits, etc. Monitor all the databases across your network from one installation of Total Access Admin.

Total Access Admin 2013 includes many new features. You can now maintain a list to translate computer names to more friendly user names, manage up to 100 database in one screen (up from 50), specify a time to close the program, more command line parameters, new forms to view the activity log, and more. Read our New Features page for details.

Monitor Microsoft Access Database Users in Real Time

Download the free, fully-functional Trial Version to see how helpful Total Access Admin can be for you. Total Access Admin 2013 supports ACCDB databases created in Microsoft Access 2013, 2010 and 2007, plus MDB databases created in any version of Access. Existing customers can upgrade at a discounted price.

Microsoft Access Difference Detector

Microsoft MVP Daniel Pineault wrote a nice review of our Total Access Detective product to find differences between his Microsoft Access databases:

Final 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

Total Access Detective Review by Daniel Pineault

Microsoft MVPMarch 26-28, 2015, Malvern, PA

Microsoft held their first US MVP Summit outside of Redmond at their offices outside of Philadelphia. FMS President Luke Chung participated and met with fellow Microsoft Access MVPs and MVPs with other specialties.

MVP Open Day Participants
All the MVPs

Microsoft Access MVPs at MVP Open Day
Access MVPs: Andy Tabisz, Jack Leach, Dirk Goldgar, Luke Chung, and Scott Diamond

MVP Open Day with Doug Ware
Doug Ware, former Access MVP and current SharePoint MVP

Microsoft Access to SQL Server Migration Services

We've completely revamped our Microsoft Access to SQL Server Upsizing Resource Center with links to all our related whitepapers and Microsoft resources to help with the whole upsizing process and use of 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.

New Microsoft Access to SQL Server Upsizing Resource Center

Microsoft Access Email Automation

Total Access Emailer lets you send personalized email blasts from Microsoft Access databases using your data and reports. It bypasses the limitations of Microsoft Outlook and MAPI by using SMTP.

Google offers a free SMTP server for gmail accounts that you can use with Total Access Emailer. Google recently added an extra security setting that you need to specify to enable the smtp.gmail.com feature.

Read our updated Total Access Emailer FAQ for more details.

Royalty free Microsoft Access VBA/VB6 Source Code LibraryNovember 5, 2014

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.

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

For more information on Total Visual SourceBook read our Blog post: Total Visual SourceBook 2013 Ships

New York TimesSeptember 23, 2014

FMS President Luke Chung was quoted in today's New York Times article HealthCare.gov Is Given an Overhaul. Robert Pear asked Luke about the overhaul that the Healthcare.gov web site needs. He quoted Luke with:

“Instead of being user-friendly, the original website was user-hostile”

In response to the quote, Luke wrote a new blog post covering some of the issues the original designers of the Healthcare.gov site missed, and how a data entry application should be designed. It's not that difficult if you know what you're doing and have done it before:

Designing a Data Entry System Properly; Overhauling the Healthcare.gov Web Site

Microsoft Access Statistical AnalysisAugust 18, 2014

Total Access Analyzer is the most popular Microsoft Access database documentation program. In our pursuit of excellence, we have released free updates of Total Access Analyzer 2007 and 2010.

Two updates were released:

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, 64-bit version, support Windows 8

Click on the links above for more details. Existing customers should have received email notification to download an update. If your email address changed, contact us to update your information.

Evening of September 8, 2014, Microsoft Headquarters

FMS President Luke Chung is the featured guest speaker for the Microsoft Access User Group meeting in New York City.

Luke will discuss and demonstrate FMS products for Microsoft Access, and answer any questions about his experiences with technology, media, and business.

Join him at this free event. More details to follow on our Upcoming Events page.

Microsoft Access Statistical AnalysisJuly 31, 2014

Total Access Statistics is the most advanced data analysis program for Microsoft Access. It extends the power of Microsoft Access queries with a wide range of statistical calculations including percentiles, frequency distributions, correlations, regressions, rankings, running totals, financial cash flow analysis, data normalization, crosstabs with Chi-Square, t-Tests, ANOVA, non-parametrics, probabilities, and more.

Total Access Statistics is now available for Microsoft Access 2013. Total Access Statistics 2013 includes many enhancements since the prior release of Total Access Statistics 2010:

  • Support for the 32 and 64 bit versions of Access 2013 with separate add-ins for each
  • New redistributable runtime libraries to support Access 2013, 2010, 2007, and 2003
  • Support for Windows 8 (and all Windows versions supported by Access)
  • Improved performance when analyzing large data sets
  • For Percentiles, when assigning percentile values to a field in your table, you can specify calculations such as quartiles, quintiles, octiles, deciles, etc. rather than just percentile
  • Field format is set to Percent for percentage fields in the Frequency, Crosstab (when percentages are in columns), and Chi-Square details tables
  • When tables are generated from the add-in, the field column widths are resized to show the entire field name and data
  • Updated user manual and help file

Microsoft Access Data Analysis: Download the Trial Version of Total Access StatisticsHere's a complete list of new features.

Download the free trial version and send your own personalized emails from Microsoft Access.

You've created a Microsoft Access database solution and have successfully distributed it to many people. Everyone is running it properly but one machine is triggering this error. The error message makes no sense and everything you try fails to resolve the problem. What's going on?

Class not registered Run-time error -2147221164 (80040154)

Read our new paper Microsoft Access "Class Not Registered" Run-time Error '-2147221164 (80040154)' to learn more about why this occurs and how to resolve it.

How did the IRS not have backups and lose Lois Lerner's emails and other files? Who came up with their backup and disaster recovery plan? Wrong policies, incorrect execution? Incompetence or intentional?

Hannity TV Show on June 19, 2014

A 3.5 minute live interview with Sean Hannity in New York with Luke at their Washington, DC studio.

Sean Hannity Radio Show, June 20, 2014

A more in-depth 14 minute discussion with David Kennedy on the radio show. Luke starts at about 2:30 after the introduction.

Additional appearances on the Sean Hannity TV and Radio Shows, Other Shows

Free Trial for Microsoft Office 365

Have you been curious about Microsoft cloud offering of Office365? No longer interested in hosting your own Exchange Server? Want to have your infrastructure in a secure data center with high reliability and resilience?

If so, we have Free Trials for Office365. We also have trial links to Microsoft Dynamics CRM. Test it out and see if you like it.

We switched to Office365 over a year ago starting with our Exchange Server. We already had our email hosted offsite, but moving it to Office365 was relatively smooth and made it easier and cheaper to support different mobile devices. We then migrated our SharePoint platform to Office365. That was a bit more challenging with the changes between SharePoint versions.

Microsoft Access ProductsNow with our hosted SharePoint site, we're experimenting with Access 2013 Web Apps that are integrated directly with SQL Azure databases for our internal and external users. Since it's hosted on SQL Azure, you can also link to the tables directly from your Access desktop databases.

Try it out for free and see what you think.

Microsoft Access Products

FMS has worked with Microsoft Access since it debuted in 1992. There have been many Access versions since then with multiple service packs, hot fixes and updates. This paper offers a list of what and when it was released, feature differences between versions and additional details for the more recent versions.

To help us remember all the versions and changes, we've written a new article summarizing the evolution of Microsoft Access: Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History.

Here's a related article we introduced in the last newsletter that is updated with a link to the new Microsoft Access 2013 SP1 Runtime download: Microsoft Access Runtime Distribution and Free Downloads

Visit our Microsoft Access Developer Help Center for additional articles with tips for creating great solutions.

Microsoft Access Email AutomationJune 5, 2014

Total Access Emailer is the most popular email automation program for Microsoft Access. It simplifies the sending of personalized emails with Access data and reports to everyone on your list.

Total Access Emailer is now available for Microsoft Access 2013. Total Access Emailer 2013 includes many enhancements since the prior release of Total Access Emailer 2010 and the Version x.6 for pre-Access 2010 versions:

  • Enhanced setup for Windows 8 and 64-bit installations
  • Support differences in VBA code between Microsoft Access 2013 and 2010
  • Improved support for linked tables in SQL Server and Access databases including situations when connections are lost
  • User interface improvements to better manage editing and duplicating email blast specifications
  • Professional Version VBA library detects if the user's machine has not run the runtime distribution EXE
  • Improved display of record counts for repeating multiple email blast broadcasts
  • Improved error handing and reporting
  • Updated user manual and help file

Here's a complete list of new features.

Download the free trial version and send your own personalized emails from Microsoft Access.

Remote Desktop lets you connect to a computer located elsewhere and run it as if you were there. Unfortunately, the remote computer’s Start menu only shows options to "Log Off" and "Disconnect". It does not offer the standard "Shut Down" options: Log off, Shut down, Restart, Stand by, Hibernate. If you attempt to use Ctrl+Alt+Del, the command is captured by the local machine and not the remote one.

Read our paper on Rebooting a Remote Desktop Computer to Restart It on how to get around this problem.

The Microsoft Access 2013 Runtime, Service Pack 1 was just released. Get the free download if you want it. Keep in mind that many features which exist in Microsoft Access 2010 no longer exist in Access 2013, so if you need them, you may be better off staying with the Access 2010 runtime which is also free. Visit our Microsoft Access Runtime Download page for more details and free download links for the different Microsoft Access versions.

Microsoft Access and SharePoint

Microsoft Access program managers gave four presentations at the recent SharePoint conference in Las Vegas. Their presentations covered how Access 2013 Web Apps can be created on SharePoint 2013 and automatically uses a SQL Server database (hosted in SQL Azure).

Links to the four videos are here: Microsoft Access Videos from the SharePoint Conference

FMS Newsletter

March 2014 Email Newsletter

Sign up if you don't already have it delivered to your Inbox.

Microsoft Access Database SchedulerMarch 21, 2014

Total Visual Agent 2013 with support for Microsoft Access 2013, 2010, and 2007 is now shipping. The 2013 version includes many new features from the 2007 version:

  • Support for Microsoft Access 2010 and 2013
  • Support for 64 bit Operating Systems
  • Simplified Startup and Easier Management of Multiple Microsoft Access Versions
  • Import Settings from Multiple Versions of Total Visual Agent
  • Test All Actions for an Event, Database, Directory or Task Group
  • Create Events that Run Every X Minutes
  • Create Events that are Limited to Periods Spanning Midnight
  • Process Directories with Managed Databases
  • Data Extract Tables are Keyed
  • Run Macros for Database Password Protected Databases
  • Pause for a Fractional Minute
  • Compressed Archive File Names Support Multiple Extensions
  • More Detailed Activity History Log with Deletions
  • More Detailed Database Statistics with Deletions
  • Add Your Comments to Events, Directories, and Actions
  • Simplified Addition of New Actions
  • More Modern and Improved User Interface
  • New User Manual and Help File
  • And More...

A fully-functional, free trial is available. Existing owners of Total Access Agent can order an upgrade at a discounted price.

Microsoft Access Spell CheckerFebruary 19, 2014

Two new versions of Total Access Speller are shipping for Microsoft Access 2013 and 2010. Many new features were added since the 2007 version:

  • Support for Microsoft Access 2010 and 2013, with 32 and 64-bit support
  • Machine and User Installation Options
  • Improved Spell Checking of Macros
  • New Option to Ignore Invisible Controls
  • Property List Shows Built-In Status
  • Enhanced user manual and help file

A free trial is available. Existing owners of Total Access Speller can order an upgrade at a discounted price.

New York TimesCreators Still in Demand on Health Care Website

February 11, 2014

Robert Pear of The New York Times called Luke and quoted him in this article: Creators Still in Demand on Health Care Website

Healthcare.gov problemsThe contract for the Healthcare.gov site has moved from CGI Federal to Accenture, but Accenture doesn’t really have a better team to put in place. In the typical large government contractor world, the winner of a contract simply hires the existing team and moves them to their payroll. The people who do the work remain and change their business cards. Do we really expect significant improvements from a team that created the original site and thought it was ready for the public?

"This appears to be a typical government contract shuffle,” Luke Chung, the president of FMS, a software development company in Vienna, Va., said of the handoff. “A new company wins the contract and hires many of the old people. It happens all the time in government."

FMS BlogDecember 15, 2013

FMS President Luke Chung provides a detailed technical assessment of the new Healthcare.gov web site in this new blog post

Who Thinks the Relaunched Healthcare.gov Performance Metrics are Acceptable?

Healthcare.gov ProblemsThanksgiving Week 2013

A crazy week of media. Before leaving town, FMS President Luke Chung was interviewed in Washington DC. Then while visiting family for Thanksgiving, the national media sent news crews and booked studio time in Sarasota, Florida to get his comments about the soon to be updated Healthcare.gov web site.

MSNBC

Luke appeared on a panel with three others for a live interview discussing the relaunched Healthcare.gov web site.

His appearance is available and summarized by Noah Rothman in this article: Tamron Hall Interrogates Tech Expert After He Criticized Supposed ‘Improvements’ to ACA Site

FOX and Friends

ObamaCare: Mistake or moneymaker?

A one-on-one interview with Clayton Morris for four minutes discussing how large government contractors profit from delivering systems that don't work:

"If we follow the money, we'll see the stink in the system...Too Big to Fire"

Featuring Sarasota Bay behind him.

Tory Dunnan had a Skype call with Luke to better understand the capacity of the relaunched Healthcare.gov site. This interview was cut into multiple stories that aired all day long. Here's one of them appearing at 1:30:

"So the challenge isn't how many lanes do you have on the highway, but it's how fast the cars can go down the highway. Because if there's any breakdown, you can have a big traffic jam and pile up behind you."

More details: Deadline Day: Obama administration 'on track' for website goal, agency says


Crucial Weekend for Healthcare Web Site

A portion of Luke's taped interview from yesterday was also included in the following morning's Today Show at 1:06:

"The system either works or it doesn't work....the 50,000 number that they've put out is a little ambiguous because what one wants to know is how many people per hour can get through the system."

NBC Nightly News

Deadline hours away for Obamacare website fixes

The Obama administration has just one day to get its Healthcare.gov website running more efficiently, but officials are already trying to limit expectations once again.

This was the lead story of the evening news. Starting at 0:45, Luke makes a few comments in response to Secretary Sebelius' comments that people should use the new Healthcare.gov web site during off-peak hours:

"It tells me the system isn't full baked. This system should be able to accommodate as many people who want to get on as possible."..cut to President Obama..."50,000 is not a number that's unheard of for websites to be able to support at one time. So I think the challenge is not just the number of users, but whether there are still bugs in the system that will prevent the process from running smoothly."

Luke Chung Quoted in New York Times for Healthcare.gov

FMS President Luke Chung has been a technical resource for Robert Pear of the New York Times since he originally quoted him in an article that kicked off all this media attention on October 8th. Yesterday they chatted about how a web site needs to be built to support maximum volume which will come on the deadline date. Quite a challenge since they can't even support the early volume.

His article appears on the front page: A Plea to Avoid Crush of Users at Health Site

Luke Chung, the president of FMS, a database company in Virginia, said building the website to handle 50,000 simultaneous users was “not unreasonable.” But he said the government must be prepared to handle much larger numbers at peak times like Dec. 23, just as the Internal Revenue Services does at the tax filing deadline in April.

CNN

White House: Enroll in Obamacare, but not too fast

After confirming he wasn't involved with the Healthcare.gov project, Luke was interviewed by Leigh Ann Caldwell about the new rollout while trying to board to flight at the airport:

Luke Chung, president and founder of Virginia-based software development company FMS Inc., said success for the website would be determined by both the number of users as well as how long they are in the system. He compared it to a highway, noting that 50,000 people traveling 60 miles per hour is smooth traffic while the same number going 10 miles per hour is a jam...Chung cited December 23 as the most significant deadline, noting that demand would be "huge" because people by nature wait until the last minute to act.

Healthcare.gov Problems

Will HealthCare.gov be in good health by Nov. 30?

Greta van Susteren is on vacation, so Luke chatted with Kimberly who was in New York City while he was on Greta's studio in Washington, DC. They discussed how these contractors are "Too Big to Fire"

"Over time, I'm beginning to see that these government contractors who took over this project have essentially made every decision that favors them as much as possible – to maximize the cost to taxpayers, to maximize their profits."

Related article by Greg Richter based on the broadcast: Software Developer: ACA Website Designers Just Lining Own Pockets

Luke Chung on CNN Situation RoomNovember 22, 2013, Seattle, WA

While attending the Microsoft MVP summit and Microsoft Access Day, CNN tracked down FMS President Luke Chung to interview him for the evening show.

He taped a segment from the Seattle studio which provided a nice Seattle Space Needle backdrop. Former Microsoft Access Program Manager, Tim Getsch, who is now the owner of Check Out My Cards (comc.com) joined him for the shoot.

Luke was asked to comment on the need for anonymous shopping on the Healthcare.gov website. He appears at 1:50 for a short quote in this 4:30 story:

"This is something people expect when they visit any web site to not disclose any personal information until they're at a point where they want to make a commitment to buy."

Watch the video: Where's the anonymous shopping perk?

November 21, 2013, Bellevue, WA

FMS President Luke Chung joined several other Microsoft Access MVP speakers at this one day event for Microsoft Access developers. In addition to Luke, speakers included the organizer Armen Stein of J Street Technology, George Hepworth, Tom van Stiphout, Andrew Couch from the UK, and Kevin Bell from Microsoft.

Luke discussed upsizing Microsoft Access databases to SQL Server and SQL Azure.

Microsoft Access Day Conference
Luke Chung Speaking at Access Day

Visit the Access Day web site for more information.

November 13, 2013, Cannon House Office Building, Washington, DC

FMS President Luke Chung testified before the US House of Representatives Committee on Homeland Security about the Healthcare.gov website. This committee is responsible for all security issues on .GOV web sites. The hearing was entitled: Hearing: Cyber Side-Effects: How Secure is the Personal Information Entered into the Flawed Healthcare.gov? Luke is on the second of two panels.

FMS Development Team Blog Click on the blog post link for video of his five minute prepared testimony and responses to Chairman Michael McCaul. His written testimony is also available. Under oath, he will make a 5 minute statement then respond to questions from all the members of the committee: Invited by the House Committee on Homeland Security to Testify about Healthcare.gov

Healthcare.gov problems

FMS President Luke Chung continues to influence the national discourse on Healthcare.gov. The technically flawed website even led to President Obama talking about web site design. As someone who identified serious problems from the day it debuted (see earlier blog posts), Luke has been on numerous national TV and radio programs discussing the issues beyond too many users.

He also wrote a new blog post on how to redesign the site: FMS Development Team Blog Creating a Healthcare.gov Web Site that Works

The Fiscal Times
Greta van Susteren on Fox News
  • November 6: Greta van Susteren's On The Record Show on Fox News
Sean Hannity Radio Show
MSNBC
Obamacare glitches known ahead of time?

NBC News

FMS Development Team Blog Blog Post of the national media coverage

Healthcare.gov problems

Read the blog from FMS President, Luke Chung, about his experience using the Affordable Care Act (Obamacare) web site when it debuted on October 1st.

FMS Development Team Blog Healthcare.gov is a Technology Disaster

Regardless of the politics, this web site is not ready for prime time. Luke offers his assessment with screenshots of several crashes he experienced. Bad design, bad development, and seemingly no testing for what should be an enterprise quality application.

As one of the few non-partisan technical reviews of the website, the blog has attracted a lot of media attention and showcased our decades of database development expertise.


New York TimesMichael Shear of the New York Times interviewed and quoted Luke in this October 8th article: Health Exchange Delays Tied to Software Crash in Early Rush

"It's poorly designed," said Luke Chung, the president of a database company in Virginia who has publicly criticized the site in recent days. "People higher up are given the excuse that there are too many users. That's a convenient excuse for the managers to pass up the chain."

Luke was included in the national morning broadcast of CBS News. Read the text or watch the video in Obamacare website looks “like nobody tested it,” programmer says

“It wasn’t designed well, it wasn’t implemented well, and it looks like nobody tested it,” said Luke Chung, an online database programmer.

Chung supports the new health care law but said it was not the demand that is crashing the site. He thinks the entire website needs a complete overhaul.

“It’s not even close. It’s not even ready for beta testing for my book. I would be ashamed and embarrassed if my organization delivered something like that,” he said.

CNN News

Luke was featured in an article on CNN entitled Obamacare glitches known ahead of time? Brian Todd came by the office to learn more about the challenges Luke encountered and the web site actually crashed while he was showing it.

FOX News

ObamaCare website neither fast or easy? Peter stepped through the site and struggled to even get a user name. Then Luke made a few comments around 1:11 and at the end of the segment:

Fox News with Peter Doocy

“It’s written as if it were created by people who had never created a database web application before…This can be fixed in a very short period of time, and it wouldn’t necessarily be that expensive”

Luke Chung comes on to talk about the root cause of Obamacare’s website hick-ups… (7 minutes)

KABC McIntyre in the Morning

Here’s my interview with Dave Ross of Ross Fire on KIRO Radio, a CBS Radio station in Seattle:

RossFire Radio Show
A computer expert’s take on the ineptitude of Obamacare online

Database expert Luke Chung has suddenly become an expert on the failings of the Obamacare computer system, all because it kept crashing as he tried to get a quote. Dave Ross and Luke go in depth on what Luke found after he dug into it (stunning ineptitude) and how he could fix it easily for a fraction of the cost. Whether you’re a geek or not, you’ll enjoy this fascinating conversation.

This is Luke's most in depth interview on the HealthCare.gov website. It includes his experience meeting with the House Energy and Commerce Committee staffers on Thursday, ways to improve the system, and how the Affordable Care Act can help FMS and other small businesses.

Send personalized Microsoft Access emails with data and reports using Total Access Emailer

George Moore, an Access developer from Dallas, Texas shared his recent experience implementing Total Access Emailer:

“Bought and configured Total Access Emailer for a client to send out numerous Alert reports to various people in the organization. Works like a champ (which is what I've come to expect from FMS), makes my client contact look like a genius and is helping the organization go through a complete culture change as a result of timely analytical reports.

You guys ROCK!!! Thanks for all you do to help us in the field."

Thanks George for your kind words. We're thrilled your client is able to transform their operations with our product and how easy it was for you to implement! For additional customer testimonials, visit our Total Access Emailer Reviews page.

Microsoft Office 2010 Service Pack 2

New Paper on the enhancements and issues related to the recent release of Microsoft Office 2010, Service Pack 2 (SP2).

Includes download instructions, details about the products affected, the list of enhancements for all the products and Microsoft Access, the Access 2010 runtime version, known issues including a confirmed bug between Access 2010 SP2 and SharePoint 2013, and additional Microsoft Office resources.

Microsoft Access add-ins and databases should never be installed in the C:\Program Files folder. Learn more about this issue related to User Access Control even if the user has administrative rights.

Custom Software for the Natonal Archives in Washington DC

To ensure the quality of work performed by their Facilities Management service providers, the National Archives and Records Administration performs both random and targeted inspections of completed work orders.

FMS was selected to create a professional, multiuser system to collect the inspection results electronically and generate a variety of management reports.

Within two months, we deployed our solution which offers data entry screens to replicate a variety of existing forms and many new management reports. An intuitive user interface made it easy for users without requiring extensive training. More importantly, we established a solid database foundation to improve NARA processes both today and into the future.

Read the Case Study: Inspection Software for the National Archives and Records Administration (NARA)

Microsoft Access

Discover what we learned when we encountered a database that would inconsistently lose its compiled state for some users. The compiler would flag field references to the form's RecordSource as missing fields, but the fields existed. So why was this happening at random times for different users?

It turns out that it's due to programmatically changing the RecordSource of forms, which may not be the form where the compile error is triggered.

Learn more about this on our blog: FMS Development Team Blog Microsoft Access Inconsistent Compile Error for a Field Reference in a Form.

Recommended Products

FMS is pleased to share that our Total Access Analyzer and Total Visual CodeTools are featured on Mark Tabladillo's product recommendation list for 2013. His recommendation list include products for analytics, big data, and data mining professionals and based on his personal use of them.

Glad you found them valuable and thanks for taking time to provide the endorsements!

We are very pleased to announce our new technical support site (http://support.fmsinc.com) to provide forums and the ability to submit technical support tickets.

Our new site lets you submit requests and respond to them via email with our support team. It also lets you visit our site to check the status of your requests and their entire chain of communications. You can login directly or use affiliated logins from Facebook, Google, and Twitter.

You can also read information and ask questions to the community. We hope you'll join us.

Microsoft Access started at the beginning of the Windows revolution 20+ years ago and became the most popular database of all time. More recently, additional technologies have become significant, so it behooves the Microsoft Access community to be aware of the trends and options. A variety of platforms and options are available with benefits and limitations with each. Meanwhile, Microsoft Access is also evolving with their latest Access 2013 version offering new web based solutions.

Read our new paper entitled Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers on what we're seeing and experiencing.

Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers

Microsoft Outlook Tips and Techniques

When travelling in Texas recently, I received an email for a noon lunch appointment the following week. So I added it to Outlook on my Windows Phone as usual.

Unfortunately, I missed the appointment because when I returned home to Eastern time, the appointment appeared on my calendar as 1 PM (noon in Texas). Rude, embarrassing, and bad for business.

Read our new paper on why and how to avoid this: Missing an Appointment Set on a Smartphone while in a Different Time Zone

Link Analysis and Data Visualization

MIT Technology ReviewAs the rampage and manhunt in Boston transpired, MIT Technology Review published an article that mentioned our Sentinel Visualizer product from our Advanced Systems Group.

In the 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.

Through the power of link analysis visualization, geospatial mapping, timelines, social network analysis (SNA), and other tools to find people trying to hide their identities and activities, Sentinel Visualizer maximizes the value of the data in your knowledgebase.

The article is entitled Building a Picture of the Bomb Suspects through Social Network Analysis. For more information, visit here.

Microsoft Access Query Beginner Tips and Techniques including VBA, DAO, and ADO

Read our new paper: Microsoft Access Query Sorting on Multiple Date (or Numeric) Fields Containing Blank Values

Learn how to sort on multiple date fields when null values exist by using a calculated field. By using the IIf and IsNull functions, you can easily sort to see the most recent (or oldest) records.

Additional information and examples are provided to show why using the NZ function (NullToZero) is not equivalent and returns the wrong results.

This new paper is part of our Microsoft Access Query Help Center.

Microsoft Access

Updated paper on Data Entry and Navigation Shortcut Keys for Microsoft Access.

Learn these keystrokes to simplify your use of MS Access as a user or developer.

The Washington Post

FMS President, Luke Chung, responds to a Washington Post article which described the experience of a local small business. They ran into trouble with Microsoft Access and were forced to migrate to another system. While there may be legitimate reasons to migrate, Microsoft Access took the blame for a poorly designed system which couldn't even support a trivial multiuser environment. The actual problem wasn't the technology, but the ignorance and incompetence of the developer who built that system.

Read more about it in the blog: Mistakenly Blaming Microsoft Access instead of the Developer

Portland Access User GroupMay 4-6, 2013, Silver Falls State Park, Oregon

FMS President Luke Chung was one of the featured speakers at this annual Microsoft Access conference hosted by the Portland Access User Group. This will be his third year speaking at this wonderful event.

He enjoyed an amazing, rustic getaway to a beautiful state park with fellow Microsoft Access enthusiasts.

Luke participated in various talks on Microsoft Access development, running a business, and creating solutions using Visual Studio LightSwitch. He'll also be staying at the site during the entire conference.

For more information, visit the conference site.

Microsoft MVP

FMS President, Luke Chung attended his first Microsoft MVP Summit at Microsoft Headquarters in Redmond, WA. Since the MVP program was created 20 years ago, FMS has had three other MVPs in the group. This was the first year Luke was added to the group. Here are some of his comments about the experience:

Attending the Microsoft MVP Summit in Bellevue/Redmond, WA

FMS Development BlogOur Blog has Moved to WordPress

We've migrated our blog to WordPress from our previous BlogEngine.NET platform. We hope you like it.

WordPress has become the most common Blogging format, so we're happy to simplify the process for people to participate in our blog with their existing WordPress login. We also gain considerably more options for designing the layout of our blog.

We could have started our new blog from scratch but since our existing blog existed for many years, we wanted to migrate it with all the comments from our BlogEngine.NET host to WordPress. That turned out to be a challenge that required learning the idiosyncrasies of BlogEngine and WordPress. With the help of Microsoft Access, we created a table with the terms that needed to be translated, read the XML file from BlogEngine, then created a new XML file that WordPress would import.

For details of how we did it, visit:
Migrating BlogEngine.NET Posts to WordPress with Translations Using Microsoft Access

Visual Studio Lightswitch Consulting

The Visual Studio team has introduced a development platform called LightSwitch which simplifies the creation of database applications in Visual Studio. This rapid application development environment lets you create solutions that can be easily deployed on Windows or Mac platforms from a public web site or Intranet.

We've been using LightSwitch for the past year and find it to be ideal for a particular class of SQL Server based solutions. Here our first article providing an overview of the benefits and limitations of the LightSwitch platform for the Microsoft Access community.

If you're interested in learning more about our help developing custom solutions based on LightSwitch, visit our LightSwitch Consulting page.

September 10, 2012

FMS President Luke Chung attended the New York Microsoft Access User Group Meeting.

Luke Chung was a featured presenter at the free New York City event hosted at Microsoft Headquarters located at 1290 6th Ave., between 51st and 52nd Streets.

Luke discussed and demonstrated FMS products for Microsoft Access, Azure cloud computing, plus answered questions about his experiences.

On August 14, 2012, Microsoft released a security update that included an update to the Windows Common Control MSCOMCTL.OCX.

Unfortunately, this update causes problems with existing Microsoft Access applications that use the common control such as the Treeview and ListBox controls. This includes the Treeview used in the Database Explorer feature of our Total Access Analyzer program (when viewing the database documentation results).

Microsoft provides a workaround for this problem in a Knowledgebase article, but it doesn't always work. We've come up with a solution that addresses this problem reliably. Read our article on Fixing the Microsoft Windows Common Control MSCOMCTL.OCX security update for more details.

Total Access Analyzer is the most popular Microsoft Access product of all-time! In conjunction with the release of the Microsoft Access 2010 version, we've added many of the new features to the Microsoft Access 2007 and 2003 versions.

In addition to the comprehensive documentation and analysis of your database objects, macros, and VBA module code, Total Access Analyzer version X.9 adds:

  • Detection of Additional Errors and Suggestions
    • Timer Interval and Timer Event Mismatch
    • Queries Using Other Queries with Both having GroupBy Clauses
    • Action Queries Opened by OpenQuery Command
    • SQL Server list of reserved words updated for SQL Server 2012
  • Displaying Additional Documentation Results
    • ActiveX controls appear as a New Category under General
    • New Table-Fields folder under Tables lets you view field properties across all your tables in one screen
    • Enhanced Opening of Referenced Object in Design Mode (view the documentation and immediately jump to the object to make changes)
  • Report Enhancements
    • Preview Multiple Reports at One Time
    • Color Customization for Reports
    • Enhanced Macro Dictionary Report
    • Many New Reports
  • New Module VBA Documentation and Options for Microsoft Access 2007
    • Advanced Macro Documentation and Analysis
    • Temporary Variable Documentation and Analysis (TempVars)
  • Improved User Experience
    • Support for Windows 7 (in addition to XP and Vista) and Office Themes
    • Installation options for the current user or machine, with support for User Access Control permissions

Existing customers with premium support subscriptions receive the upgrade for free. Other existing customers can upgrade for a nominal fee. Demo available.

Thank you for your support in making Total Access Analyzer such a great success!

Total Access Analyzer is the most popular Microsoft Access product of all-time! Documenting and analyzing your database objects, macros and VBA module code, Total Access Analyzer helps you understand what's going on. Take control of your MS Access applications and find errors and ways to improve their design and performance. Over 300 issues are pinpointed with 380 presentation quality reports for comprehensive documentation and cross-referencing of your application. Winner of every Best Microsoft Access Add-in award with great reviews, Total Access Analyzer remains the "Must Have" tool for serious Microsoft Access developers and people who inherit existing Access solutions.

What's New

Visual Studio Lightswitch ConsultingJuly 1, 2012

Microsoft has officially recognized FMS President Luke Chung as a Microsoft MVP for his support of the Microsoft Access community.

Since the official launch of Microsoft Access, Luke Chung has been at the forefront of the Microsoft Access community (read his impression on the day Microsoft Access debuted). He has written numerous articles, spoken at conferences around the world, and collaborated with the Microsoft Access development team over the years. His leadership propelled FMS to the world's leading third party vendor of commercial products for Microsoft Access.

Congratulations Luke!

Microsoft MVP Trophy
Microsoft MVP Certificate for Luke Chung

Microsoft Access

FMS developer Molly Pell is featured as a guest blogger on the Microsoft Access developer blog with two articles:

Using a Combo Box to Search

This post demonstrates a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box.

Using a Microsoft Access ComboBox to Filter as you Type

Check out the post here: Using a Combo Box to Search as you Type.

For more combo box tips, check out our Top 5 Combo Box Tips for Access.

Microsoft Access Crosstab Queries in Reports

This post demonstrates how to use the Pivot statement to control column names returned by crosstab queries, allowing crosstabs to be used on reports.

Microsoft Access Crosstab Query

Check out the post here: Using crosstab queries in reports

Or read our technical paper with a sample database: Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query

Microsoft Access

Read our new paper on:

Microsoft Access Database Architecture: Storing Temporary Data and User Settings

There are many things a user does with an application that need to be preserved either during processing, between screens, between sessions, or between application updates/versions. When designing a system, it's important to consider what to keep and where/how to do this. If designed properly, the data should also support multi-user environments.

Problem

Users are commonly annoyed to be forced to re-enter their last specifications when the application should start with that as its default. After all, a computer is supposed to be good at remembering things, right?

Solutions

There are several ways to preserve user information during a session, on a PC, and/or between PCs:

  • Keeping Selections in Memory for the Current Session
  • Using the Registry to Store User Information Between Sessions
  • Using Private Tables to Store Information Between Sessions
  • Making Sure Previous Values Remain Valid

Read the Microsoft Access Temporary Data paper for more details and tips.

Portland Access User Group

In May, FMS President Luke Chung presented at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. Luke participated in a variety of discussions and gave a presentation on Taking Over a Legacy Microsoft Access Database Application. Check out the paper and PowerPoint presentation.

Microsoft Access Database Architecture: Storing Temporary Data and User Settings

Situated at the beautiful Silver Falls State Park Conference Center, Luke and some fellow participants took a hike through forest and the many waterfalls there:

PAUG Group Hike

Space Shuttle Discovery Fly-By

The Space Shuttle Discovery on a 747 with fighter jet escort flies by our offices three times this morning. It banked right in front of our windows to head back to DC.

They eventually flew over us toward the Smithsonian's Udvar-Hazy National Air and Space Museum at Dulles Airport where it will be on permanent display.

See more pictures on our FMS Facebook Page Facebook album.

The Microsoft Access 2010 version of Total Access Analyzer is now shipping with support for the 32 and 64 bit versions of MS Access 2010.

We've added many new features to support Access 2010, generate more useful documentation, identify more errors, and suggest more design improvements and best practices. There's advanced validation of macro commands, macro printouts showing indented syntax, temporary variable cross-referencing and verification, improved query performance analysis, etc.

We've also enhanced the user experience with the ability to open a cross-referenced item in design mode while viewing the information, previewing multiple reports at once, and adding color to all reports. Here is a description of the new Access 2010 features. Existing customers can upgrade at a discounted price.

Press Release

Luke Chung and Governor McDonnell

FMS President Luke Chung was invited by the governor's office to participate in his proclamation of 2012 as the Year of the Entrepreneur. Luke stood behind Governor Bob McDonnell and Lieutenant Governor Bill Bolling during the press conference and participated in a day-long event supporting entrepreneurship, small businesses, and job creation.

Commerce Secretary James Cheng led the events. Participants were able to hear from successful Virginia business founders and learn from each other through a luncheon and Entrepreneurial Town Hall. Examples of agricultural, technology, manufacturing, and craft businesses showed the diversity of Virginia firms offering products and services for in-state, national and international customers. It was also interesting to trace the roots of the founding of Virginia in 1607 as a high-risk entrepreneurial enterprise that eventually led to success after many failures.

See a video on the local NBC news:

NBC News Coverage

FMS Development Team BlogFor more information, read our FMS Participates with Virginia Governor's Declaration of 2012 as the Year of the Entrepreneur.


News ArchiveLegacy Press Releases

FMS Resources

 

"Thanks! FMS products are extremely powerful, unbelievably stable, great timesavers, easy to learn, and an absolute pleasure to work with!"

Alison Balter, Author, Trainier, Consultant

 

Questions

 

 

Free Product Catalog from FMS