FMS News Archive


This is what a government shutdown looks like to contractors. We have a small project with Amtrak to support a Microsoft Access application. They sent us this letter after the budget impasse in Congress.

The suspension isn’t a big deal to us since we don’t have dedicated staff supporting it. It’s awful for contractors with larger commitments and their staff who are unlikely to be compensated for the shutdown.

After posting on Twitter about the letter we received from Amtrak in regard to the Government Shutdown, FMS President Luke Chung was contacted by WUSA9 and the Huffingtonpost.

WUSA9WUSA9, December 26, 2018

On December 26, 2018, FMS President Luke Chung was quoted by John Henry from WUSA9 on our FMS, Inc. government contract suspension in his #ShutdownStories. It was featured on the 11pm News and WUSA9 website!

To read the article and watch the video, visit #ShutdownStories: Government contractors tackle life without pay during partial shutdown.

Huffingtonpost, December 27, 2018

HuffingtonpostOn December 27, 2018, The Huffingtonpost quoted FMS President Luke Chung:

“Business owners who have [dedicated] staff are making the decision: Do we pay people or not, even though we won’t get paid by the government?” Chung said. “Either you force people to take vacation, or you pay them, to be a good company ― but depending how long it drags on, one may not have a choice.”

For the full article, visit Shutdown Leaves Government Contractors Without Work And Likely No Back Pay.

To read more on the Government Shutdown, visit our blog post, Government Shutdown's impact on the Contractors and Employees and leave us a comment about your experience.

Microsoft SQL Server Microsoft Azure and Cloud ComputingDecember 19, 2018

FMS President Luke Chung wrote a new paper on eliminating the default database security holes with Microsoft SQL Server on Azure.

Do not allow all Azure resources permission to your Azure SQL Server databases. Set the permissions to OFF to disallow all Azure services to connect to your SQL server:

Turn off Microsoft SQL Server Azure Allows All Azure Services

Step-by-step instructions are provided to allow specific IP Addresses or range of IP Addresses that are permitted to get data from your server and databases.

Visit our page Microsoft Azure Security Holes with SQL Server Databases for more information.

FMS Newsletter

Our December newsletter is now available!

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

FMS December 2018 Newsletter

Total Access Analyzer

December 2018

Total Access Analyzer examines all your database objects to provide extensive documentation, code analysis, object cross-reference, and diagrams with over 390 presentation-quality reports. It detects 300+ types of errors, suggestions, and performance tips, so you can learn and apply Best Practices to fix problems, improve your design, and speed up your Access applications.

Enhancements

  • Supports Microsoft Access 2019, 32-bit and 64-bit versions.
  • Document All Database types supported by Microsoft Access 2019.
  • Improved Blueprint Documentation.
  • Additional Cross-Reference and Validation including Subform References.
  • Total Access AnalyzerImproved Memory Management.
  • Data Macro Documentation.
  • Document Workgroup Security in ACCDBs.
  • Better Support of Documentation for Multiple Databases.
  • Module Bracket Reports.
  • Improved User Interface Shows more Progress Details.
  • New Manual and Context Sensitive Help.
  • and more...

Existing Total Access Analyzer owners are able to upgrade at a discounted price.

Total Access Analyzer

December 2018

New updates for Total Access Analyzer are available for Microsoft Access 2016, 2013, 2010 and 2007. Total Access Analyzer is the most popular Microsoft Access add-in, that 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.

Enhancements

  • Additional Cross-Reference and validation of tables, queries, fields and controls across your database objects, including references in subforms.
  • Improved form and report blueprint documentation to capture large and complicated designs and layouts.
  • Improved memory management for documenting large Access databases to minimize the chance of running out of memory.
  • Data macro documentation and cross references to related tables.
  • Documentation of workgroup security settings for ACCDBs if they were converted from MDBs with workgroup security.
  • Improved user interface to show progress of the documentation.
  • Revised user manual and help file.
  • and more...

For more information, visit:

Download the Free Trial to experience it for yourself.

Decades of Quality ResultsOctober 10, 2018

FMS, Inc is celebrating its 32nd year! Since we started in 1986, FMS has become the world's leading developer of products for Microsoft Access developers and a top vendor of products for the SQL Server, Visual Studio .NET, and Visual Basic communities.

With tens of thousands of customers in over 100 countries, FMS customers are comprised of a variety of organizations from small to large including 90 of the Fortune 100 and every US federal government department. Our experience and processes for developing commercial off-the-shelf software deployed worldwide is applied throughout all our development efforts.

We at FMS, Inc. want to thank our customers for choosing us and we hope we can continue serving you in the future.

Microsoft Access ACCDE and MDE Database Recovery Service

Do you only have the ACCDE or MDE database files but can't find the original ACCDB and MDB files that created them?

We provide a database recovery service to convert ACCDE and MDE databases to ACCDB and MDB files. Also, we rescue data and other objects from a corrupt Access database.

We need to perform an assessment of a few hours to see if a recovery is possible, and if so provide the cost for doing it. This service is only provided if you have ownership of the solution and intellectual property.

For more information, visit Microsoft Access Database Recovery Service.

Microsoft AccessOctober 9, 2018

Many Microsoft Access users have recently been confronted with this error when they open their database on Windows 10 machines:

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

Microsoft Access Database is in an 'inconsistent state'

We wrote a blog post on a potential workaround for this error. Please share your experiences!

October 4, 2018

FMS President Luke Chung met with Emanuel Gonzalez-Revilla the Ambassador of the Republic of Panama to the United States.

They had a nice candid discussion about the business climate in Panama, the work he did there before becoming ambassador, his role as US ambassador, relations between the US and Panama, relations between Panama and other countries, especially China, banking Panama and the Panama Papers scandal, raising his two college age sons, and what he may do after his 5 year term expires next year.

For more information on Ambassador Emanuel Gonzalez-Revilla, visit the Embassy of Panama.

Panama Ambassador Emanuel Gonzalez-Revilla

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


KABC Radio Los Angeles (AM 790): McIntyre In The Morning

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

KABC McIntyre in the Morning

Ross Fire Show on KIRO Radio Seattle

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.


Total Access Emailer Customer Shares His Experience

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 Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhancements and Issues

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 New Tip: Do Not Install Microsoft Access Add-ins and Databases in the Program Files Folder

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 on our support page, Do Not Install Microsoft Access Add-ins and Databases in the Program Files Folder.


Custom Software for the Natonal Archives in Washington DC New Case Study: Inspection Software for the National Archives and Records Administration (NARA)

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 New Tip: Microsoft Access Inconsistent Compile Error for a Field Reference in a Form

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 Two FMS Products are on Microsoft MVP Mark Tabladillo's 2013 Recommendation List

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!

Try the free trials for Total Access Analyzer and Total Visual CodeTools and see for yourself.


New Technical Support Forum and Ticket Tracking

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.


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

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 Be Careful Making Appointments on Your Smartphone from a Different Time Zone

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 Sentinel Visualizer Mentioned in MIT Technology Review with Boston Marathon Bombing

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 Building a Picture of the Boston Marathon Bombing Suspects through Social Network Analysis.


Microsoft Access Query Beginner Tips and Techniques including VBA, DAO, and ADO Microsoft Access Queries: Sorting on Multiple Date (or Numeric) Fields with Blank Values

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 Microsoft Access Shortcut Keys for Data Entry and Navigation

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.


2013 Portland Oregon Microsoft Access User Conference

Portland Access User Group May 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.


The Washington Post Blaming Technology (Microsoft Access) Rather than Developer Incompetence

March 10, 2013

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.


Microsoft MVP Attending the Microsoft MVP Summit

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:

The MVP conference brings together 1500 professionals from across the world to this conference. The MVPs cover all the different product groups for Microsoft which offers a wonderful mix of expertise and enthusiasm.

Attending the Microsoft MVP Summit in Bellevue/Redmond, Washington.


FMS Development Blog Our 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 New Paper on Microsoft Visual Studio LightSwitch for Microsoft Access, SQL Server, and Visual Studio .NET Database Developers

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.


New York City Microsoft Access User Group Meeting

September 10, 2012

FMS President Luke Chung attended the New York Microsoft Access User Group Meeting. He 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.

For more information on future events, visit our Upcoming Events page!


Fixing the Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update

August 14, 2012

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 onFixing the Microsoft Windows Common Control MSCOMCTL.OCX security update for more details.


New Version of Total Access Analyzer for Microsoft Access 2007 and 2003

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 for Microsoft Access 2010 Update and Demo Version

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 Consulting FMS President Luke Chung is a Microsoft MVP

July 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 AccessFMS Guest Blogs on the Microsoft Access Developer Blog

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
  • Microsoft Access Crosstab Queries in Reports

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 Microsoft Access Database Architecture: Storing Temporary Data and User Settings

FMS President Luke Chung wrote a new paper, 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 New Presentation: Taking Over Legacy Microsoft Access Database Applications

May 2012

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 Space Shuttle Discovery Flies by Our Offices Three Times

April 17, 2012

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.


Total Access Analyzer for Microsoft Access 2010 Ships

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.

Read more about Total Access Analyzer 2010 Press Release. Try the Free Trial today!


Luke Chung and Governor McDonnell FMS Participates with Virginia Governor's Declaration of 2012 as the Year of the Entrepreneur

February 22, 2012

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.

NBC News Coverage

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


Portland Oregon Microsoft Access Database Designer Conference

Silver Falls State Park Conference Center
May 5-7, 2012

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. Join him and other guest speakers at the beautiful Silver Falls State Park Conference Center.

Microsoft speakers include Ryan McMinn, Microsoft Access Senior Program Manager Lead, and Kevin Bell test engineer on the MS Access team. Other speakers include industry authors and notables F. Scott Barker, Alison Balter, Juan Soto, and Armen Stein.

Luke will be giving a new presentation on Tips and Techniques for Taking Over and Existing Access Application.

For complete details and registration, visit PAUG Conference Site. See photos from last year's conference on our Facebook page.

Total Access Detective Ships for Microsoft Access 2010 with Updates for 2007 and 2003

We are pleased to announce the release of Total Access Detective for Microsoft Access 2010 with support for the 32 and 64-bit versions of MS Access 2010. We've also released an X.8 Version update for Microsoft Access 2007 and 2003.

Ever wonder what changed between your database versions or the difference between two similar objects or tables? Total Access Detective is the premier program to detect differences between Microsoft Access databases, objects, code, and data.

Available as a Microsoft Access add-in, Total Access Detective lets you easily find differences between objects in your currently opened database. Easily find changes in your table and field definitions, object properties, controls, report sections, embedded macros, regular macros, modules, and data. The results are available to you in reports and on screen which can be copied or exported.

You can also compare any two databases to easily find exactly how they changed. Your databases can be an ACCDB, MDB or ADP database format. The new version lets you create separate databases for each comparison so you can easily manage multiple databases and changes over time.

We've added many new features to make Total Access Detective more powerful than ever:

  • Supports Microsoft Access 2010, 32 and 64-bit versions
  • Compares All Database Types Supported by Access 2010
  • Compares the new Microsoft Access 2010 enhancements including new object properties, macro syntax, and VBA commands
  • Performs Line-by-Line Comparisons of Embedded Macros
  • Procedures that Did Not Change are Listed
  • New Data Comparison Option to Ignore Case Differences
  • When Comparing Modules, Optionally Ignore Blank Lines and Comments (also applies to text block comparisons)
  • Exclude Properties from Comparison
  • Create and Manage Multiple Database Comparison Results. You are no longer limited to one set of comparison results!
  • Command Line Launching of Total Access Detective Can Now Specify Storage Database Name
  • Improved User Interface with Office/Access 2010 Theme Support
  • New Reports and Improved Selection Screen
  • New User Manual and Context Sensitive Help

Manually comparing databases for design and data differences is prone to error. Discover why so many Microsoft Access professionals rely on Total Access Detective to improve their productivity by quickly identifying the changes in their work.


Microsoft Access ActiveX Controls on a FormTotal Access Components 2010 Ships with 32 and 64-bit Controls

Create dazzling forms with Total Access Components, the only collection of custom controls designed specifically for Microsoft Access.

With little or no code, add advanced menus, rotated text, bitmap animation, resizer and splitter bars, progress meters, gauges, dials, sliders, spin buttons, pop-up notes, Windows dialogs, clocks, fancy buttons, borders, rotated tabs, cursors, etc. A sample database includes examples of every control and how to customize them.

The 2010 version is rebuilt using C++ version 10 and supports both 32 and 64 bit platforms without having to make any changes to your forms or code.

Total Access Components 2010 supports Access 2000 through 2010. It includes a royalty-free distribution license and a deployment program to easily distribute it to your users. Here are the new features. You can also download a free trial version.


Total Access Startup for Microsoft Access 2010 is Now Shipping

Total Access Startup 2010 (Version 14.0) lets you centrally manage and guarantee that all your users always launch the right version of Microsoft Access with the right version of your Access database (MDB, ACCDB, or ADP). Simply distribute a shortcut to your users to start your application. When you post an updated database, your users automatically get it installed on their machine the next time they launch your program. They don't need to know the name of the database. You manage all of that in one place and can change it at any time. A runtime version lets you control the Access version launched for users not on your network.

Total Access Startup 2010 supports both 32 and 64 bit versions of Microsoft Access 2010 letting you control which version your application requires. It also supports all legacy versions of Access. Learn more about the new features and try out the free trial version.


Total Access Analyzer Product Review

Geoff Hollander of Northwest Database Services and the Portland Access User Group wrote a review of our Total Access Analyzer product. He provides a nice discussion of how it finds ways to improve his Access applications:

"I always thought that I was thorough about going through an application and cleaning up loose ends, but Total Access Analyzer proved: I was wrong and I probably won't call another application complete until Total Access Analyzer gives it the OK."

He also suggests how the documentation it generates and its reports are a business opportunity:

"Selling a documentation package generated by Total Access Analyzer for your application is a great way to add a training-free, trouble-free and reasonably priced profit center to the work you are already performing! ...Total Access Analyzer is a solid product that any Access developer should have in their toolbox; and one that will pay for itself in short order."

Read the full review on our website.


Participating on the Senate Finance Committee's Small Business Roundtable

September 15, 2011

FMS President Luke Chung was invited by the Senate Finance Committee to share his experiences as a small business owner. As one of 18 participants, Luke was asked about his experience running FMS and how tax policy can hurt and help small businesses thrive and create jobs. In a very bipartisan environment, the staffers of co-chairmen Senator Max Baucus (D-Montana) and Orrin Hatch (R-Utah) listened to the participants who provided a perspective quite different from the deep pocketed lobbyists they normally experience on Capitol Hill.

Read more about it in Luke's Blog: Participating on the Senate Finance Committee's Small Business Roundtable.


Total Visual CodeTools for Microsoft Access 2010 is Now Shipping

Discover why so many professional developers rely on Total Visual CodeTools to make them more productive.

Integrated directly into the Integrated Development Environment (IDE), Total Visual CodeTools offers a rich set of developer tools to help you create, cleanup, and deliver better solutions. The latest version is enhanced for MS Office/Access 2010 and has many new features.

Total Visual CodeTools supports all VB6/VBA hosts, including Visual Basic 6.0 (VB6) and Office 2010, 2007, 2003, 2002/XP, and 2000.


Download the Free Preview of Total Visual CodeTools for Microsoft Office Access 2010

June 2011

Download the free preview of Total Visual CodeTools 2010 for Microsoft Office/Access 2010. The Preview Version is fully functional through the end of July. Take advantage of this opportunity to see how Total Visual CodeTools can cleanup the code in your existing projects, let you deliver more robust solutions, and simplify your daily coding chores.

Integrated directly into the Integrated Development Environment (IDE), Total Visual CodeTools gives you a rich set of tools to help you create, cleanup, and deliver better solutions. The latest version is enhanced for MS Office/Access 2010 and has many new features:

  • Supports Microsoft Access/Office 2010, 32-bit version
  • VBA Code Parsing Supports Access/Office 2010
  • Code Cleanup and Code Delivery Allow Immediate Overwrite
  • Code Cleanup Error Enabler and Handler Tags are Customizable
  • Copy Control Builder Supports Multiple Target Controls
  • Long Text/SQL Builder Supports Query Retrieval and Converts Tabs and Spaces
  • Select Case Builder Supports Text Blocks and Numeric Ranges
  • Recordset Builder Defaults to Current Database and Simplifies Selections
  • Three Locations for Total Visual CodeTools on Your Menus
  • Tools Available During Debugging
  • Default 'Send To' is Remembered
  • Screens are Resizable
  • Redesigned Storage of Standards for Improved International Support

Visit these pages for:

Total Visual CodeTools supports all VB/VBA hosts, including Visual Basic 6.0 (VB6) and Office 2010, 2007, 2003, 2002/XP, and 2000.


Photos from the Portland Access User Group Conference

June 4, 2011

Check out the photos from the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. FMS President Luke Chung spoke at the event and had a delightful time in the hills of Silver Falls State Park.

Can't wait to attend next year's event!


Creating a Backup and Disaster Recovery Plan for Your IT System

Entrepreneurs' Organization DC chapterFMS President Luke Chung wrote a new blog post that was recently published on the Entrepreneurs' Organization, Washington DC web site discussing the need of small business owners to Create a Backup and Disaster Recovery Plan for Your IT System. Luke has been a member of EO for over a decade and previously served as the Washington DC chapter president.

Disaster RecoveryThe article covers our experiences working with people running small to medium sized organizations, and the challenges they face to address business process continuation issues. An overview of the basic steps are covered.

To read the full article, visit our blog post Create a backup and Disaster Recovery Plan. This is related to a recent article: Creating a Backup and Disaster Recovery Plan for Microsoft Access Database Applications


Microsoft Access Enterprise FeaturesPublished Article: Microsoft Access Is Underrated: Your Hatred Of Microsoft Access Is Largely Unjustified

The Enterprise Features web site highlight's FMS President Luke Chung's discussion about why Microsoft Access is underrated and hated in large enterprise organizations.

He discusses the dynamics of IT departments in large organizations and their natural conflict with the needs and budgets of information worker. He also shows how organizations that understand the strengths and weaknesses of Microsoft Access can leverage its power for competitive advantage, and how to structure service levels to do so.


Portland Microsoft Access User Group Luke Chung Speaking at Portland Access User Group Conference in May 2011

May 14-16, 2011

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. Join him and other guest speakers including Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, and Kevin Bell from Microsoft.

Luke will be speaking on the following topics:

  • FMS Products for Microsoft Access Developers and How they Make You Money
  • Microsoft Access and Azure: Working in the Cloud
  • Microsoft Access Disaster Recovery Plans

For complete details, visit PAUG 2011 Database Designer Conference! For more information on future events, visit our Upcoming Events page.


Microsoft Access 2010 Luke Chung Presenting at the Denver Area Access User Group

April 5, 2011

FMS President Luke Chung will be the guest presenter at the April 5th meeting of the Denver Access User Group. He'll be discussing Microsoft Access 2010, FMS products for Microsoft Access, and all things Access. See you there!

DAAUG Meeting
April 5, 2011 from 6 to 9PM
Microsoft USA - Rocky Mountain District
Denver, CO 80237

For more information on future events, visit our Upcoming Events page.


Total Access Emailer Microsoft Access 2010 Total Access Emailer for Microsoft Access 2010 is Now Shipping

March 2011

Total Access Emailer is the most popular Microsoft Access email program. Running as an add-in, it lets you easily send personalized emails using the information in your database. From using fields in the subject and body of the message, to attaching PDF reports filtered for each recipient, you'll find that Total Access Emailer revolutionizes the way you communicate with your contacts. Any table or query can be the data source for your emails which can be in text or HTML format. We can even automatically include graphics in your HTML emails or let them reference a public site.

We are very pleased to announce Total Access Emailer for Access 2010. Enhancements include support for Access 2010, 32 and 64 bit, compressing all your attached files into one zip file with optional password, international extended character support, a new Code Generator, additional programmatic interfaces, and many more new features. An X.6 upgrade version for Access 2007 and earlier versions also available. Download the Free Trial.


Link Analysis and Data Visualization New Version of Sentinel Visualizer Released

Sentinel Visualizer is our commercial, off-the-shelf product that brings the power of data visualization, link analysis, geospatial, timeline, Social Network Analysis (SNA). We recently released version 4.6 which includes many new features to empower analysts to better understand hidden relationships in their data:

  • Integration to Google Earth Version 6 to map entities
  • Upgraded Declutter tool – filter by value of Degree, Entity Weight, Entity Value, Relationship Weight, and Relationship Value
  • Export subset of link charts into a new window to perform additional analysis
  • Send a selected network to a new visualizer window without having to re-create the network
  • Improved data-import routines including saving schemes for reuse, avoiding duplication of imported data, and more import options

Learn more about Sentinel Visualizer built on SQL Server.

Total Access Admin Microsoft Access Total Access Admin for Microsoft Access 2010 is Now Shipping

December 2010

Total Access Admin lets you monitor your databases to see who's currently in it. It's ideal for understanding who's currently connected, compacting databases after everyone has exited it, and troubleshooting multi-user problems.

The Total Access Admin 2010 supports Access 2010 and 2007. In addition to supporting 2010, it now lets you monitor multiple databases in one screen. You can perform actions across all the databases, watch the activity in real time, and log the users entering and exiting each database. Visit New Features for complete information. Total Access Admin 2003, version 11.5, is also released for Access 2003 and earlier. Try the Free Trial today!


Total Access Statistics Microsoft Access 2010 Total Access Statistics for Microsoft Access 2010 is Now Shipping

September 2010

Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the power of Access queries to let you generate a wide range of values such as percentiles, regressions, running totals, correlations, group analysis, etc.

Total Access Statistics is now shipping for Microsoft Access 2010. In addition to supporting the 32 and 64 bit versions of Microsoft Access 2010, version 14 offers new financial cash flow analysis to generate net present value (NPV), internal rate of return (IRR), modified IRR (MIRR) for periodic and date dependent investments and receipts. New Features for Access 2010.

A new X.8 version is also available for Access 2007, 2003, 2002, and 2000. This is free for customers under a support contract, and is available for a nominal upgrade fee for others. Try the Free Trial today!


FMS Papers Featured on the Microsoft Access Team Blog

August 21, 2010

Our two papers on Microsoft Access, Windows Azure, and SQL Azure are featured on the Microsoft Access Product Development Team Blog!


Microsoft Windows AzureMicrosoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud)

FMS President Luke Chung has written a detailed paper on his expectations of cloud computing and its revolutionary impact on our industry. He considers it the most significant trend since the rise of the Internet in the mid-1990's.

He's written two articles on this topic.

Then, think about how the ability to create and host enterprise quality databases can impact what is possible for you.


Total Access Statistics 2010 Preview Version Extended

Microsoft Access 2010 Microsoft Access June 25, 2010

We've updated and released a new version of the preview version of Total Access Statistics for Microsoft Access 2010. The original version expired on July 1, 2010, but this version is good through September 1, 2010. We hope you get a chance to use it and provide feedback on what you discover.

Download the Total Access 2010 Preview Version today!


Total Access Statistics Total Access Statistics 2010 Preview Version Available

May 26, 2010

We are pleased to announce the availability of the preview version of Total Access Statistics for Microsoft Access 2010. Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the data analysis capabilities of Access queries to let you perform advanced numerical analysis on your data. Use any Access table, linked table, or query to perform calculations such as percentiles, regressions, frequency distributions, t-Tests, correlations, non-parametrics, rankings, moving averages, etc. It can also perform data normalization and let you select random records. As you would expect in a query, you can specify Group By fields so analysis is performed on each set of records with identical group fields.

Total Access Statistics runs within Access with all output in Access tables. It supports MDB, ACCDB, and ADP databases. In addition to supporting Access 2010, we've added financial calculations for cash flows. It now calculates net present value (NPV), present value (PV), future value (FV), internal rate of return (IRR), and modified internal rates of return (MIRR).

This FREE preview is available with support for both the 32 and 64 bit versions of Access 2010. It includes both the interactive wizard that runs as an add-in, plus the programmatic VBA library so you can embed statistical analysis in your applications. The preview version is fully functional through July 1, 2010.

Download the Total Access 2010 Preview Version today!


Luke Chung Appointed to Fairfax County, Virginia's Information Technology Policy Advisory Committee

Fairfax County Virginia May 25, 2010

Approved by the Board of Supervisors, FMS president Luke Chung will serve on the county's Information Technology Policy Advisory Committee (ITPAC) to advise the county's board and CTO on the future direction of information technology investments. Having served several years on a business and community advisory committee for the superintendent of public schools, Luke is representing the school board on this committee.

"It's an honor to serve on this board to help our county and it's 1,000,000+ residents maximize the use of technology to improve services, safety, education, and good governances while minimizing overall costs", said Luke Chung. "Over the years, Fairfax County has established itself as a state and national leader through solid business growth and high quality public education. With constrained budgets, I expect we will continue that tradition through the smart application of technology."


Total Access Admin 2010 Preview Version Available

Microsoft Access Database Monitor Microsoft Access April 16, 2010

We are pleased to release a FREE preview version of Total Access Admin 2010 for your review. Total Access Admin lets you monitor Access databases in real time. Select any Access Jet database (MDB or ACCDB) across your network to view and log users as they enter and exit your database.

It's particularly useful for documenting suspect connections that could be the source of database corruption. You can also perform a variety of tasks such as locking new users from opening your database, compacting the database after everyone has exited, etc. The existing version supports Access 2007 and earlier. This new version support Access 2010 for both 32 and 64-bit formats, along with databases from earlier version of MS Access.


Total Zip Code Database Now Has Geospatial Latitude and Longitude

April 2010

One of the nicest features to add to an address data entry screen is to automatically fill the city and state fields when a zip code is entered. In conjunction with the US Postal Service, FMS offers the Total Zip Code Database which gives you the entire list of valid zip codes and their corresponding city and state names. Both the primary and secondary city names are provided. Speed up data entry, eliminate typos, and clean up existing data with Total Zip Code Database. We also include the list of common city names the USPS doesn't like with their corresponding corrections. The database is provided on an annual subscription basis with an initial list and 11 monthly updates.

In addition to the information provided by the USPS, the Total Zip Code Database also includes geospatial coordinates (latitude and longitude) for each zip code. We also provide a list of countries and states to simplify lookups, and module code and sample form to add this to your applications. The data is provided in a Microsoft Access MDB and ASCII files.

For more information, visit the Total Zip Code Database page, view the zip code flier, and try the Free Trial today!

Total Zip Code Database United States Postal Service


New Updates for Total Access Detective

Total Access Detective January 22, 2010

Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. As part of our commitment to quality, we are pleased to release updates of Total Access Detective for our versions for Microsoft Access 2007, 2003, 2003, and 2000.

The updates include performance enhancements, Windows 7 support, improved ADP support, and resolve all known issues since their original release. The updates are available free of charge to registered owners who were emailed download instructions for the update. Please contact us if you are a registered owner and did not receive a notification.


Calculating Percentiles in Microsoft Access with Total Access Statistics

Total Access Statistics January 2010

Total Access Statistics is the world's most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.

A common need among MS Access users and developers is the need to calculate percentiles. We've created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and provided in three ways:

  • A new table with each percentile value as a separate field
  • A new table with each percentile value as a separate record
  • Updating a field in your table with the percentile value corresponding to the data in your record

Total Access Emailer Programmatic Interface

Total Access EmailerJanuary 2010

Total Access Emailer is the world's leading email program for Microsoft Access. It runs as an Access add-in to let you easily create email blasts using your list of email addresses and integrating your data and reports into your messages and attachments. The Professional Version includes a programmatic interface that lets you automate the sending of email blasts through your VBA module code. A simple procedure is provided to let you launch an email blast.

For more information, visit Send Microsoft Access Email Blasts Programmatically using VBA.


Total Visual SourceBook Total Visual SourceBook 2007 Ships for Microsoft Access/Office 2007

Total Visual SourceBook is the most extensive professional source code library for Microsoft Access, Office, and Visual Basic 6.0. The latest version includes full support for Access/Office 2007 including the new Access 2007 ACCDB database, Outlook 2007, and many new features to expand the considerable source code library. There are now 194 classes/modules, 100,000+ lines of code, and almost 20,000 lines of example code.

As before, you have full control: use our code, learn from it, and enhance it. Best of all, the code is provided royalty free so you can use it in your projects immediately! Written by our staff of Microsoft MVP's, much of this code can't be found anywhere else!

AustraliaLuke Chung Speaking at Office DevCon 2009

October 31 - November 1, 2009

Brisbane, Australia

FMS President Luke Chung will be giving several presentations on Microsoft Access application development and our products at this conference. Hosted at the University of Queensland, St. Lucia campus, we hope you see him down under!

For more information on future events, visit our Upcoming Events page.


Two More FMS Articles are published on MSDN

October 2009

MSDNFMS is honored that Microsoft published two more of our popular articles on their MSDN global site:

We recently enhanced the query paper to include additional information on the Update Query syntax.


New Look and Feel for Our Web Site

September 2009

Our web site is undergoing major renovations and sports a new look and feel. While portions are still undergoing changes, much of the work is completed and published. We hope you like the enhancements with more improvements to come!


Total Access Detective Versions X.7 Ship for Microsoft Access 2003, 2002, and 2000

Total Access Detective August 2009

Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. With the recently release of the Access 2007 version, we're pleased to provide new versions for Microsoft Access 2003, 2002, and 2000 (versions 11.7, 10.7 and 9.7 respectively).

The new Version X.7 adds many new features including data comparison between two queries, enhanced data comparison options such are comparing two tables when field names are not identical (compare only identical field names or on field order), using the first field as the key field if no key field exists, skipping small numerical data differences, ignoring case differences between modules, improved support for ADP comparisons, etc. Existing customers can upgrade for a nominal fee.

Existing Total Access Detective customers under annual support contracts receive the upgrade for free.


FMS Article on Error Handling in VBA/VB6 is published on MSDN

MSDN August 2009

FMS is honored that Microsoft has published one of our popular articles on their MSDN global site. Originally, published as one of our technical papers on our web site called Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6), Microsoft has now added our paper to their MSDN site. Visit the Microsoft Page.


Free Update for Total Access Statistics 2007 and Total Access Admin 2007

August 2009

As part of our commitment to quality software, FMS periodically releases updates patches to add new enhancements and resolve known issues. We've released updates for Total Access Statistics and Total Access Admin.

Total Access Statistics Total Access Statistics is the most powerful data analysis program for Microsoft Access. Extend the power of Access queries with advanced analysis such as percentiles, frequency distributions, moving averages, t-Tests, confidence intervals, ANOVA, data normalization, and much more. Version 12.00.0009 is now available for Access 2007 and includes improved support for ADPs and certain calculations.

Total Access Adming Total Access Admin 2007 lets you monitor multi-user entries and exits to your Access databases in real-time. Watch and log the activity and catch suspect connections or drops that can cause database corruption. It can even compact your database after everyone has exited. This patch addresses some of the issues associated with supporting password protected databases and databases under workgroup security. Version 12.00.0140 is now available for Access 2007.

These updates are available free of charge to registered owners of Total Access Statistics 2007, version 12.0 and Total Access Admin 2007. Notification and download instructions for receiving the patch were emailed to registered owners. If you did not receive instructions, please contact us so we can update your information.


Total Access Detective Ships for Microsoft Access 2007

Total Access Detective July 2009

Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. Know exactly what changed with your properties, fields, indexes, controls, sections, macro lines, VBA module code, and data! List objects in one database and not the other. Find new, deleted, and modified records. Combine records from two tables into a new one. New features include support for Access 2007 and the new ACCDB database format including multi-value fields, enhanced data comparison options, improved support for ADP comparisons, and much more!


Total Visual Agent Ships with Full Support for Access 2007

Total Visual Agent July 2009

Microsoft Access databases need to be periodically compacted for optimal performance. You should also perform regular backups. Total Visual Agent performs these system administrative chores, and automates a wide range of Access tasks such as running macros on a schedule. Everything is audited with email notification of problems. Now with full support for Access 2007 and the new ACCDB database format.


Microsoft SQL Server consulting services Microsoft SQL Server Development Services

When we develop custom database applications on the desktop or web, we often store the data in Microsoft SQL Server. Contact our Professional Solutions Group for help with your database development efforts. Whether it's migrating an Access database from Jet to SQL Server or creating a highly scalable web solution using ASP.NET, our team of database experts are here to help. Learn more about our Microsoft SQL Server consulting services.


Update for Total Access Admin 2007

Total Access Adming June 26, 2009

Total Access Admin offers a real-time monitoring of users entering and exiting any Microsoft Access database across your network. An update of Total Access Admin 2007 was just released. All customers were notified of the updates via email with download instructions.


Microsoft ASP.NET Website Development Services

Microsoft ASP.NET consulting services FMS is well known for our world class Microsoft Access and desktop development skills. Did you also know our Professional Solutions Group is very experienced creating database driven web solutions using Microsoft ASP.NET and SQL Server? We recently updated our information on our Microsoft ASP.NET website development services.


Luke Chung Speaking at the Washington DC Access User Group

June 17, 2009

FMS President Luke Chung is the guest speaker at the June 17th meeting from 7 to 9 PM. Luke will be speaking on "Cool Features in Access 2007" and any other topics the audience raises. The event is free and located at the Washington DC Veterans Affairs Medical Center in Washington DC. For more information, visit Washington DC Access SIG.


Microsoft TechEd 2009 Conference Online Video from the Microsoft TechEd Conference

Watch videos of Luke Chung's participation on the Microsoft Tech Ed Conference panels.


Microsoft TechEd 2009 Conference Luke Chung Speaking at Microsoft TechEd Conference

May 11-15, 2009

Microsoft has invited FMS President Luke Chung to participate on three panel discussions at their annual conference from May 11-15th in Los Angeles. Luke will be covering:

  • Running a Software Consulting Business
  • Developing SQL Server Applications
  • Development Strategies During These Challenging Times

For more information, visit our Upcoming Events page. Hope to see you there!


Total Access Components 2007 Ships

Microsoft Access ActiveX Controls April 7, 2009

Total Access Components 2007 lets you enhance your applications with amazing visual effects, interactive features, and other features that are sure to amaze your users. Add powerful functionality to your Access application in minutes with the only collection of ActiveX custom controls designed specifically for Microsoft Access. New features include support for Access 2007, a new Cursor control, and enhancements to many controls. Download the Free Trial today!


Luke Chung Speaking at the Denver Access User Group

March 19, 2009

Luke Chung is the featured speaker at the March 19th Denver Access User Group meeting held at the Microsoft Office in downtown Denver from 6 to 9 PM. He'll be covering Microsoft Access 2007, the FMS products for Access, and entertain any questions that may arise. The event is free and we encourage you to become member of the group if you aren't already.

For more information, visit http://www.daaug.org/. For information on FMS participation in future events, visit our Upcoming Events page.


Microsoft Access and SQL Server Video MSDN Channel 9 TV - Luke Chung on Microsoft Access Database and Migration Challenges

March 2, 2009

Microsoft's Dr. Zhiming Xue interviews Luke Chung on topic of dealing with Access database solutions and challenges that project teams deal with when migrating them to more scalable solutions.

Watch Microsoft Access Database and Migration Challenges Video (22 minutes) and read more about Migrating Microsoft Access Databases to SQL Server.



United States State Department FMS is Serving the United States State Department

FMS is honored to provide custom application design and development work for the headquarters of the US State Department in Washington, DC.

The State Department is using our ASP.NET development and SQL Server database expertise to enhance one of their existing public web site which is being converted from legacy ColdFusion and Delphi technologies.

Our team of expert technologists and business analysts continually hone their skills to maximize the impact of the technology. Please contact us so we can apply our experience and expertise to your needs.


Total Access Analyzer Version X.8 for Microsoft Access 2003, 2002, and 2000 is Shipping

Total Access Analyzer January 2009

An updated version of Total Access Analyzer is now shipping for Access 2003, 2002, and 2000. Many new features were added to help you find more ways to improve your Access databases. For more information, visit New Features for Version X.8. Customers on support contracts receive the upgrade automatically, other customers can upgrade for a nominal fee.

Excel Security Patch Conflicts with Pasting Data into Access Tables

December 2008

If you're used to pasting Excel spreadsheet data into an Access table, you may have encountered this error recently: The data on the Clipboard is damaged, so Microsoft Office Access can't paste it. Maybe you thought there was something wrong with your spreadsheet, data, or memory. It turns out this is caused by a Microsoft Excel 2007 security patch that was released December 9th. For more details, visit Error Pasting Data from Microsoft Excel 2007 to Microsoft Access. Learn more about the issue and a few workarounds that our FMS developers have found.


The Hot Mommas Project The Hot Mommas Project: FMS Creates a Social Networking Website for Female Entrepreneurs

December 2008

Seeking to build the world's leading case study site for businesswomen and entrepreneurs, a professor at the George Washington University Business School chose FMS to get it done.

George Washington UniversityKey Features include:

  • Social networking features including tagging and public profiles
  • Rich text authoring
  • Search Engine Optimization (SEO) driven URLs for participants' cases
  • Great prizes for competition winners!

To read more, visit Hot Mommas Project: GW's Sizzling New Research Initiative.


White Paper: Application Development During Uncertain Times

November 2008

Read FMS president Luke Chung's white paper, Application Development During Uncertain Times. On how to best develop applications and position yourself during these challenging economic times. Balancing budgets, application requirements, and the rapidly changing external environment, a strategy that's quick and nimble is in more demand than ever. Learn how to best position yourself and your organization in these challenging times. Minimize risk and maximize your potential by getting solutions into production quickly and letting the market decide what survives and dies. Application evolution and natural selection is most powerful during times like these. Make sure you anticipate those forces.


Streamlining the Harvard College Interview Process

November 2008

Harvard University It's the season for high school seniors to apply to college. This year our Professional Solutions Group is helping Harvard College automate their interview process. Almost every student who applies to be a freshman is offered a personal interview with a local Harvard alum. With over 22,000 applicants last year, it's quite a challenge to match up applicants with interviewers, and manage all the paperwork.

Our Professional Solutions Group created a web based solution using SQL Server, Visual Studio .NET, and an Access administrative interface to assist with the process. With Harvard now providing massive scholarships based on financial need (families making under $80K a year don't have to pay anything and those making up to $200K pay only 10%), we expect an even larger pool of applicants. Best wishes to all who apply!


Total Access Speller 2007 Ships

Total Access Speller October 2008

The Microsoft Access 2007 version of Total Access Speller is now shipping with many new features. New X.5 versions are also available for Access 2003, 2002, and 2000.


Total Access Analyzer 2007 Ships

October 2008

Total Access Analyzer Thank you for your patience! The much awaited Microsoft Access 2007 version of Total Access Analyzer is now shipping. Microsoft made a big investment to create Access 2007 and added a lot of great new features with significant changes to objects, properties, VBA code, the user interface, an entirely new database format, with new field types and embedded macros.

So we now support MDB, ADPs, and the new ACCDB database formats. The user interface can be in tabbed view or traditional windows. Layer on top of that the differences between Windows XP and Vista, and you'll quickly see the number of permutations our developers and QA staff needed to address.

For more information, visit New Features for Total Access Analyzer 2007!


Total Access Memo 2007 Ships

Total Access Memo August 2008

Total Access Memo 2007 for Microsoft Access 2007 is now shipping with full support for Access 2007 through Access 2000. Easily add rich text memo fields to your forms and reports tied to your tables. Includes a built-in full screen text editor to let you easily add fonts, point sizes, styles, paragraph settings, graphics, hyperlinks, and more! You can even spell check your formatted text with support for 20 languages. Download the Free Trial today!


Free Seminar for Microsoft Access to SQL Server Upsizing Co-Sponsored by Microsoft in Reston, Virginia

June 27, 2008

Please join us for a half-day seminar on upsizing Access applications to SQL Server.

Luke Chung, FMS President, and Steve Clark, FMS Project Manager and Microsoft MVP, will present these topics:

  • Where Microsoft Access Fits in the Overall Database Strategy of an Organization
  • Approaches to Upsizing Access to SQL Server

For more information about the seminar, visit Microsoft Access to SQL Server Upsizing Seminar.


Microsoft TechEd Panel Discussion: Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

June 18, 2008

Watch the televised video of Luke Chung, FMS President, on a panel discussion at the 2008 Microsoft TechEd Conference in Orlando, Florida.

Hosted by Microsoft's Mary Chipman, the panel discusses the challenges and approaches of migrating Microsoft Access applications to SQL Server.
Watch the Microsoft Access to SQL Server Upsizing video for more details.


Total Visual CodeTools 2007 Ships

Total Visual CodeTools May 13, 2008

Total Visual CodeTools 2007 helps you write, cleanup, and deliver better VB6 and VBA code. Discover why so many Access, Office and VB6 developers rely on Total Visual CodeTools to simplify their application development, fix existing and inherited projects, and deliver more robust and supportable solutions. New features include support for Access 2007, detecting unused variables, improved code builders and utilities, and much more. Download the Free Trial today!


Microsoft MSDN Premium Subscription Special Offer Special Offer for Microsoft MSDN Premium Subscriptions

May 2008

FMS is pleased to provide a two year MSDN Premium Subscription for almost the same price as a one year subscription. If you're serious about developing applications on the Microsoft platform, you need to get this amazing resource! Available while supplies last. For mroe information, visit Microsoft Developer Network (MSDN) Premium Subscriptions.


Total Access Startup 2007 Ships

Total Access Startup March 13, 2008

Total Access Startup 2007 is now shipping. Discover how Total Access Startup ensures your users run the latest version of your database with the correct version of Microsoft Access. Centrally manage an unlimited number of Access databases across your network and simplify upgrades between versions. New features include support for Access 2007, launching ADPs, supporting multiple Access versions on the same database, and much more. For more information, check out the Press Release on the release of Total Access Startup 2007.


See you in San Diego, California!

March 2008

FMS President Luke Chung is speaking at the March 19th meeting of the San Diego Access User Group from 6-8PM. FMS is exhibiting at the Microsoft booth at the DoDIIS conference March 16-19th, 2008, so make sure to stop by if you're there. For more details, visit our Upcoming Events page.


Total Access Admin 2007 Ships

Total Access Admin February 5, 2008

Total Access Admin 2007 is now shipping. Discover how Total Access Admin lets you monitor any Access database (Access 97 through 2007) to see all the current user connections. Watch how and when they enter and exit your database in real-time, keep a log file, and troubleshoot problems. You can even set it to compact the database once everyone exits. Download the Free Trial today!

Microsoft Access Microsoft Access Help and Resource Center

Due to our extensive resources for Microsoft Access, a centralized page was created to make it easy to find all the information called Microsoft Access Help, Resources and Services from FMS. It includes a brief history of Access, our experiences with Access, links to technical papers, tips, and other resources.

New items include:


The Rational Guide To Microsoft Office Access 2007 
				TemplatesFree Book Offer for Microsoft Access 2007

Get the Access 2007 book, "The Rational Guide to Microsoft Office Access 2007 Templates" by Zac Woodall, a $24.99 value, for FREE! Through special arrangements with Zac Woodall and his book publisher, we're pleased to offer a limited quantity of his book, with the purchase of one of our Microsoft Access 2007 products.

For more information on this amazing deal, visit Free Book Offer!


New Technical Paper for Creating Monthly Summary Reports in Access

October 28, 2007

FMS President Luke Chung has written a new paper on how to create spreadsheet like reports with monthly summary columns without writing any code. For more information, check out Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query.


FMS Participating and Speaking at Advisor Summit in Miami, FL

September 30 - October 4, 2007

FMS President Luke Chung is speaking in the Microsoft Access track of this event. We will also have a booth among the exhibitors. For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.


Microsoft Access 2007 FMS Product Announcements for Microsoft Access 2007

We've been working with Access 2007 for over a year since the alpha version was released and are delighted by the considerable investment Microsoft made to enhance Access. Rather than simply porting our products to Access 2007 with the same functionality as before, we've invested the time and effort to make sure we take advantage of the new capabilities of Access 2007, added features requested by our customers, and applied the new Office/Access 2007 look and feel. For more information, visit FMS Products for Microsoft Access 2007.


Sentinel Visualizer New Product - Sentinel Visualizer Version 4.0 is Shipping

September 5, 2007

Sentinel Visualizer revolutionizes data analysis with a powerful combination of features to let you maximize the understanding of your data. Gain insight into multi-level relationships and complex networks. Apply link charts, data filtering, gradient metrics, geospatial maps, timelines, social network analysis, and much more. Read more on Sentinel Visualizer Version 4.0 Release.


Total Access Statistics 2007 is Shipping

Total Access Statistics July 20, 2007

Total Access Statistics for Access 2007 is now shipping with many new features. Enhancements for users of Access 2000, 2002, and 2003 is also available in a new X.7 Version.Additionally, the Total Access Statistics web site is updated with information on the new versions, product PDF fact sheet , new tour, etc.

Download the Free Trial today!


Total Access Emailer 2007 is Shipping

Total Access Emailer May 18, 2007

FMS is pleased to release our first product for Microsoft Office Access 2007. Total Access Emailer 2007 is now shipping and introduces several exciting enhancements over the original release, including support for the new ACCDB database format, new field types, new user interface, and the ability to attach Access reports as PDF or XPS files to your emails. Download the Free Trial today!


GSA Schedule Contract Awarded to FMS

GSA Schedule April 16, 2007

FMS receives a General Services Administration (GSA) Schedule Contract to provide software products and consulting services to the US Federal Government.


Microsoft Gold Certification for 5th Consecutive Year

Microsoft Gold Certified Partner April 10, 2007

Microsoft designates FMS as a Microsoft Gold Certified Partner for the 5th year in a row. This is Microsoft’s highest partner certification level and reflects the proven experience and expertise of FMS for creating solutions using Microsoft technology. Read more about FMS Awarded Microsoft Gold Certification.


FMS Free Links to Outside Resources

February 2007

Can't find what you're looking for on Microsoft Access, .NET, SQL Server? Visit our newly updated Microsoft Access and Office Links page and utilize the list of outside resources we've put together for your convenience.


FMS Upcoming Events

February 15, 2007

FMS is going to Disneyland! We hope to see you at the Advisor Summit on Microsoft Access and Office, on May 6-10, 2007 in Anaheim, CA. Stop by our booth and listen to FMS President Luke Chung speak about topics including:

  • Where Microsoft Access fits in the Overall Database Strategy of an Organization
  • Tips and Techniques for Taking Over an Existing Access Application
  • Best Practices for Creating Great Access Applications

For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.


National Center for Missing and Exploited Children Protecting our Children with the National Center For Missing and Exploited Children

January 20, 2007

We recently began working with the good people at the National Center for Missing and Exploited Children to see how we could help their efforts. We also learned a lot about how to better protect our children. Read FMS President Luke Chung's open letter on his experience.


Microsoft Featured White Paper, by Luke Chung

January 2007

In an effort to keep you, our customer, up with the latest advances in the industry, we have again updated one of the key white papers regarding Microsoft Access.

Learn when to use Microsoft Access and when to use SQL Server in your organization. This newly updated white paper discusses database needs, evolution, and challenges, the advantages, limitations, and myths of Access, and how to use Access and SQL Server strategically in your organization.

FMS Celebrates 20 Year Anniversary

October 26, 2006

Founded in 1986, FMS is celebrating its 20th anniversary in business. This proud achievement is a very significant milestone for us. Very few companies survive so long, much less firms in our rapidly changing technology industry. Our success over the years stems from properly serving our customers, employees, and vendors through many business and technology cycles. And, of course, the continued support our customers give us for our innovation and customer service, we thank you most of all.

FMS President and Founder Luke Chung has a message to celebrate FMS 20th Anniversary.


Total .NET SourceBook 2005 is Shipping

October 24, 2006

FMS releasedTotal .NET SourceBook 2005, the latest version of its best-selling professional source code library and code repository for Visual Studio .NET. The newest version supports Visual Studio .NET 2005 with a comprehensive collection of royalty free, ready-to-use .NET programming code in C# and Visual Basic .NET. For more information, visit New Professional Code Library for Visual Studio 2005.


New Versions of Total Access Analyzer Available

October 5, 2006

FMS, Inc. is proud to release new versions of Total Access Analyzer with many new features and enhancements. Version 11.7 is now available for Access 2003, Version 10.7 for Access 2002/XP, and Version 9.7 for Access 2000. Total Access Analyzer is the most popular Microsoft Access add-in winning every industry “Best Access Add-in” award since 1994. The new versions generate even more comprehensive documentation and analysis of Access databases to help users and developers create better solutions.


FMS President Luke Chung featured on Microsoft website

September 2006

FMS President Luke Chung is featured on Microsoft's Most Value Professional webpage. Learn when to use Microsoft Access and when to use SQL Server in your organization. This white paper discusses database needs, evolution, and challenges, the advantages, limitations, and myths of Access, and how to use Access and SQL Server strategically in your organization.


Newest Version of Total Access Emailer Available Today

July 15, 2006

We are excited to announce a new and greatly improved version of Total Access Emailer. Total Access Emailer is the leading email program for Access users and developers. Easily leverage the power of Microsoft Access and email to generate personalized text and HTML email for everyone in your table or query. Use field values from your Access tables and queries to create unique, personalized emails for each recipient. You can even maintain an audit trail to know who was contacted when. Download the Free Trial today!


Dot.net Magazine Awards Total .Net Analyzer

May 15, 2006

Dot.net magazine of Germany recently recognized Total .NET Analyzer as its Reader's Choice best software for testing, Q/A, and debugging! We are honored by this latest addition to Total .NET Analyzer's wide array of awards and rave reviews. Download a30-day Trial today and see how this award-winning product can improve your applications.


Total Access Statistics Updates Available

May 10, 2006

Total Access Statistics is the most powerful data analysis tool for Access. Total Access Statistics runs as an Access add-in and offers a wide range of statistical functions to analyze your data, including regressions, percentiles, ANOVA, t-Tests, and much more. You'll be amazed at the powerful statistical analysis you can generate within Access!

As part of our commitment to providing quality software, we have released update patches for Total Access Statistics 11.0, 10.5, and 9.5 (for Access 2003, 2002, and 2000 respectively). These updates resolve a few known issues in the products, and also include several new features. For more information, visit the Total Access Statistics Update page.


New Versions of Total Access Emailer Released

May 10, 2006

Total Access Emailer makes it easy to send personalized emails from within Access. With the release of the new X.5 versions for Access 97, 2000, 2002, and 2003, users can now use Total Access Emailer to embed access reports, tables, queries, and more! For more information on the new features, visit Version X.5. Try the Free Trial today!


Small Business Specialist Microsoft Small Business Specialist Designation

March 24, 2006

Microsoft has certified FMS as a Microsoft Small Business Specialist with experience and qualifications to address the needs of small businesses. Find out what we can do for your organization today.


SQL Server Upsizing

February 22, 2006

While many Access databases remain perfectly fine in Access, a certain number grow and evolve into applications that push the limits of Access. When is it time to grow into SQL Server? Visit the Professional Solutions Group, Upsizing page and discover why even Microsoft uses FMS data to decide when you should use a new solution.


FMS Featured in the Washington Business Journal

February 17, 2006

As recently featured in Washington Business Journal, the FMS Advanced Systems Group is leading the industry to go beyond traditional link analysis. Visit http://fmsasg.com and learn more about this exciting advancement in technology.


FMS Announces renewal of its Microsoft Gold Certification for 2006

Microsoft Gold Certified Partner February 15, 2006

Microsoft has renewed its certification of FMS as a Microsoft Gold Certified Partner. This is Microsoft’s highest partner certification level and reflects the proven experience and expertise of FMS for creating solutions using Microsoft technology.

Strategic Investment and Licensing Agreement with In-Q-Tel

October 14, 2005

As recently featured in Washington Business Journal, discover this new technology.


Steve Clark Designated Microsoft MVP

October 13, 2005

We are proud to announce that Steve Clark, Senior Project Manager, has been selected for the 5th straight year as a Microsoft Office Systems Access MVP. Each year Microsoft reviews the contributions of professionals around the globe to find the cream of the crop in dedication. In addition to being a consistent resource for Microsoft newsgroups, Steve has also been a contributing author to the Access 2003 VBA Programmer's Reference book published by WROX.


Get a Product Catalog Today

September 23, 2005

The new FMS product catalog is now available. Get to know some of the people that contribute to our success and all the latest products to "Accelerate" your work!


FMS Selected to Guest Speak at CIPS

September 21, 2005

The Canadian Information Processing Society has selected FMS to guest speak at the annual conference in Edmonton, Alberta, Canada, November 8th, 2005. For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.


Pod Cast with Luke Chung

September 16, 2005

This interview featured Access through the eyes of long-time database veteran, guru, and FMS president, Luke Chung. This Pod Cast was courtesy of OfficeZealot.com.


FMS Moves

August 15, 2005

We are happy to announce that FMS has moved. Our new address is: 8150 Leesburg Pike, Suite 600, Vienna VA, 22182-2721. Phone, Fax, and Email information remains the same.


Case Studies

June 13, 2005

We enjoy sharing success stories with you. Here are 2 success stories we are proud to highlight. Office Tools Pro uses Total Access Memo and NGP Software, Inc. uses Total Access Agent. Share your experiences with us anytime.


Visual Studio Magazine

April 22, 2005

We are proud to be in the April issue of Visual Studio magazine, page 19, with a product listing forTotal .NET SourceBook - our code library product.


Total Access Ultimate Suite

April 13, 2005

All our 2003 products for Microsoft Access are now shipping, which includes the Total Access Ultimate Suite. If you're serious about Access, this suite is what you need for significant productivity! Amaze the boss and save $2000 today!


Total Visual SourceBook

April 12, 2005

Total Visual SourceBook is the most popular professional source code library for Access, VB, and VBA developers is now shipping with support for Microsoft Access/Office 2003, as well as Office 2000, Office 2002/XP, and Visual Basic 6. This new version includes browser enhancements to customize the error handling for the FMS procedures making it simple to replace the default error handling code, plus lots of new code. Over 85,000+ lines of code and 160+ classes and modules are available for you to use royalty-free in your applications!


Total Access Analyzer Recognized by Access Advisor

April 5, 2005

The new version of Total Access Analyzer is available and brings new functionality to help Access developers control their databases by understanding how they work.


Total Access Detective

March 18, 2005

Total Access Detective allows you to easily compare objects, properties, fields, controls, lines of code, data, and more to know exactly what changed! New features include combining data differences into a new table, summary reports for databases differences, support for ADPs, and much more! Versions available for Access 2000, 2002, and 2003!


Vote for FMS Development Tools

March 15, 2005

We are proud to have our products recognized in the development tools section of MSD2D's Fourth Annual People's Choice Awards.

Vote for any of our 3 products:


Now Shipping: Total Visual Agent

March 2, 2005

All Access/Jet databases need regular maintenance for optimal performance and bloat elimination. Total Visual Agent solves your administrative chores like compacts and backups by letting you schedule these and other repetitive tasks. Total Visual Agent can now run as a Windows NT Service which lets you manage ALL your Access/Jet databases across your network securely. Supports all versions of Access (including 2003), Jet, and Visual Basic. Download the Free Trial today!


New Training Video System

January 1, 2005

Master Microsoft Access, .NET, .ASP, C#, and Visual Basic with this easy-to-follow CD-ROM collection from Blast Through Learning, a company recognized throughout North America for world-class courseware and comprehensive training courses. Industry experts Dan Balter, Paul Sheriff, Alison Balter, and Bruce Jones lead you step by step through the intricacies of using these. We are confident you will find these videos very useful, plus they are nearly 30% off regular price. Order today!

Now Shipping: Total Visual CodeTools

December 8, 2004

The new Total Visual CodeTools is shipping! The new version supports Visual Basic 6, Access/Office 2000, Access 2002/Office XP, and Access/Office 2003. Integrated directly into the VB/VBA Integrated Development Environment, Total Visual CodeTools provides a rich set of coding tools. Total Visual CodeTools helps you increase productivity and ensure that your code is efficient and maintainable. Download the Free Trial today!


New Division at FMS

November 30, 2004

We are proud to announce the new division within FMS, the Advanced Systems Group. This new group is responsible for delivering advanced analytical software to a variety of missions. Visit FMS, Advanced Systems Group today!


MSDN Event in Southeastern Virginia

October 12, 2004

FMS recently exhibited at a MSDN seminar held in Chesapeake, Virginia. The event, attended by over 70 individuals, was a huge success for FMS, who was able to publicize products and services. For information on FMS participation in future MSDN events, as well as other seminars and roundtables, visit our Upcoming Events page.


Total Access Analyzer is Shipping

October 1, 2004

The most popular Access add-in of all time is now available for Access 2003, plus an updated version 10.5 supporting Access 2002. The new version offers over 200 "Best Practices" to flag errors, offer suggestions, and much more. Download the Free Trial today!


Featured on: Let's Talk Computers Radio Show

August 27, 2004

Luke Chung, FMS president and founder, discusses software tools that are available to developers. Listen to the recorded radio interview today.


Software Solution for City of Phoenix

August 13, 2004

The City of Phoenix has chosen FMS to provide operational consulting services and software support to its waste management department.


Sentinel TMS

July 10, 2004

Sentinel Threat Management System has recently been included in Microsoft's Justice and Public Safety catalog.


FMS and Council for Christian Colleges & Universities (CCCU)

June 29, 2004

Featured New Database System in Microsoft meeting.


Association Management Software

June 5, 2004

FMS delivers association management software for a major custom .NET application to manage memberships, relationships, and events for non-profit university organization headquartered in Washington D.C.


Total Access Emailer for Access 2003

April 19, 2004

"I recently purchased Total Access Emailer for Access 2003. I just want to say what a great program it is. We send invoices and dispatch data electronically (in text or Xml format) from our Access database. It used to be a rather cumbersome having to manually attach files that we had created using Access. Now, with just a click of a button, Total Access Emailer takes care of the entire process. Thank you!" - Phillip Kershaw, Triumph International (NZ) Ltd.


Now Shipping Total Access Statistics for Access 2003

April 16, 2004

Total Access Statistics for Access 2003 is now shipping with many new features and analysis types. New versions for Access 2000 and 2002 are also available with these enhancements.


Tech Deputies

April 14, 2004

Washington Business Journal reports: "Local firms capitalize on software that connects the dots for law enforcement. The heightened level of security has led to higher levels of government funding to fight terrorism, and officials with companies selling connect-the-dots software, such as Vienna-based FMS and Springfield-based i2, hope this will lead to increased demand for their products." - Neil Adler, Staff Reporter


Product Review for Total .NET Developer Suite

April 4, 2004

"The Total .NET Developer Suite looks and feels very much like it is OEM and not a third-party add-in." - Sanders Kaufman, Builder.com


Visual Studio Magazine Readers Choice Awards

March 29, 2004

FMS has received two, 2004 Visual Studio Reader's Choice Merit Awards. Total .NET SourceBook was recognized for Development Tools and Total .NET Analyzer for Performance, Profiling and Debugging Tools.


Get a FREE FMS Catalog Today

February 25, 2004

Our entire product line in one catalog. This issue includes the MSDN Universal Subscription for only $1,499 when you purchase any FMS Suite and after the Microsoft DVD rebate - regularly $2,799.


Now Shipping Total Access Emailer for Access 2003

February 24, 2004

Total Access Emailer lets users and developers create and send emails based on their data. Download the Free Trial today! Versions available for Access 97, 2000, 2002, and 2003!


Cast Your Vote Today!

February 13, 2004

The asp.netPRO First Annual Reader's Choice Balloting has begun! FMS is proud to be in the category of Add-in with Total .NET SourceBook and the Utility category with Total .NET Analyzer. Support asp.netPRO and FMS, vote today!


SD Times Highlights FMS .NET Tools

January 28, 2004

In the February 1st issue of SD Times, page 21, article titled "Building On .NET", features our very own Dan Haught.

MSDN Subscriptions - Huge Savings With FMS!

December 16, 2003

Purchase the MSDN Subscription from FMS and receive a $800 discount. And now for a limited time FMS will take an additional $200 off when you purchase the MSDN Subscription with any FMS Product Suite. Buy the Total .NET Developer Suite, Total Access Developer Suite or Total Access Ultimate Suite and pay only $1799 for the MSDN Subscription. That's $1000 in savings! (retail price $2799). Supplies are limited.


Technical Paper on Access

October 21, 2003

FMS President Luke Chung wrote a new paper called Database Evolution: Microsoft Access within an Organization's Database Strategy. Whether you use Access or not, you'll want to read this detailed paper exploring the role of Access (the world's most popular database) in today's rapidly changing IT environment. Written by FMS president Luke Chung, this paper summarizes our experience with the use of Access across enterprise of all sizes. Discover how the strategic and proper use of Access maximizes your ROI and gives your organization a competitive advantage. This paper also analyzes the power of database evolution and how you should embrace and anticipate its impact throughout your organization.


Product Feature for Total Access Emailer

October 10, 2003

In the October issue of Visual Studio Magazine, Total Access Emailer is featured.


Product Review for Total .NET XRef

October 9, 2003

In the November issue of Visual Studio Magazine, Total .NET XRef is presented in the First Looks section. "A cross-referencing tool such as Total .NET XRef can be vital to supporting large, complex systems, and a lifesaver when you maintain other people's code. You can make changes with fewer unintended side effects when you can see every place where the code uses a data item. If you work with heavily used module-level variables or find yourself changing frequently used methods, Total .NET XRef can help you avoid making serious mistakes." - Andy Clark, Reviewer


Customer Service

October 1, 2003

"Geez, Nifty Products (like the Code Libraries), Spiffy Customer Service, and Super Prices (Great Value to the End User)... No Wonder folks keep coming back to FMS! It *is* kind of amazing the ugly level of customer service that's out there... Which makes is all the more refreshing when we get to deal with folks like Jessica and FMS. Thanks Again!" - Kevin Keith


Microsoft Case Study Featuring FMS

September 25, 2003

Maintaining a Competitive Edge: Improving Business Process with the .NET Framework features FMS and client MediVia.


Product Review for Total Access Emailer

September 12, 2003

"Email jobs are saved so they can be edited and reused. You also get statistics and reporting after a blast has gone out. There's even a programmatic interface in case you'd like to add emailing capabilities to your own Access applications. All in all, a nice piece of work." - Mike Gunderloy, Developer Central 32


Total Access Emailer Highlighted

September 12, 2003

Total Access Emailer is highlighted in the product listing section of the October issue of Visual Studio Magazine.


Product Review for Total Access Emailer

September 11, 2003

"FMS Total Access Emailer lets you generate personalized e-mail messages in text or HTML format for everyone in your table or query." - Advisor Zone


Product Review for Total Access Admin

September 10, 2003

"The FMS Total Access Admin helps you perform tasks such as fixing database corruption and logging off idle users in order to perform maintenance." - Advisor Zone


Microsoft Approves Total Access Startup

September 9, 2003

Total Access Startup has been approved by Microsoft for quality standards and will now appear with the Microsoft "Designed for Microsoft Windows XP, 2000, ME, 98" logo. Discover this superior product today.


Total .NET SourceBook featured in Tool Gallery

September 5, 2003

Total .NET SourceBook is featured in the Visual Studio Magazine Tool Gallery. Discover more with Total .NET SourceBook today.


Total Access Startup Featured in 46 Advisor Publications

September 1, 2003

Total Access Startup is featured in 46 Advisor Zone publications including the Microsoft Access Advisor Zone. Use the tool to launch a database with the appropriate version of Access every time.


FMS, Microsoft Gold Certified Partner

Microsoft Gold Certified Partner August 24, 2003

FMS is now a Microsoft Gold Certified Partner, the highest designation for a Microsoft partner, and another example of FMS's commitment to deliver the best Microsoft solutions and services.


iX Magazine

August 20, 2003

The German Magazine iX plans to publish a list of tools for Microsoft .NET Framework 1.0/1.1. FMS is proud to announce our entire .NET product line has just been included in this special issue.


FMS Contributes to Advisor Magazine

August 19, 2003

In the September issue of Access-VB-SQL Advisor Magazine Troy Munford writes "Overcome a Common Access ActiveX Problem, Learn how linking tables at runtime affects ActiveX on forms and reports", page 22. Jim Ferguson writes "Avoid Unwanted Events in VB.NET", page 50. And Dan Haught has the Tip of the Month with "Decompile an Access Database to Improve Performance", page 50.


Product Review for Total .NET Analyzer

August 18, 2003

In the September issue of Visual Studio Magazine, page 11, "My favorite category is "Unused," which reveals unused assignments and variables—dead code that invariably winds up lying around once development is complete... The documentation is clear and thorough, and technical support is courteous and responsive. The tool had difficulty parsing one of my projects, and a friendly representative handled my call. Within a few days, FMS released a new version that fixed the problem." - Leonard Lobel


The .NET Developer's Journal 2003 Readers Choice Awards

July 18, 2003

The .NET Developer's Journal is accepting your votes for the 2003 Reader's Choice Awards until August 30th. Our products, Total .NET SourceBook and Total .NET Analyzer have been nominated in a number of categories. We would be grateful if you could take a moment and cast your vote for your favorite FMS .NET tool.


Product Update: Total VB Statistics

July 17, 2003

As part of our commitment to providing quality software, we have just released an update for Total VB Statistics 6.5. The latest version of Total VB Statistics is 6.5.5. Download the Free Trial today.


Product Update: Total Access Memo

July 15, 2003

As part of our commitment to providing quality software, we have just released an update for Total Access Memo 10 (for Access 2000 & 2002). The latest version of Total Access Memo 2002 is 10.01.0000. Download the Free Trial today.


Total Access Startup Highlighted

July 10, 2003

Total Access Startup is highlighted in the product listing section of the July issue of Visual Studio Magazine.


Product Review: Total .NET SourceBook

June 27, 2003

"Moving and copying code snippets around from the Sourcebook to your Visual Studio project and vice versa is, as they say, a breeze. I was very impressed with the way you can highlight a chunk of code in your project and simply drag it onto a node in the sourcebook to create a new sourcebook entry automatically. Very neatly done." - Ged Mead, DevCity.NET


Product Review: Total .NET Analyzer

June 20, 2003

Mike Gunderloy compares three .NET tools and says, "Of the products I’ve looked at here, Total .NET Analyzer takes the most detailed look at code from all angles of best practices."


Total .NET Analyzer Featured in Advisor Zone

June 15, 2003

Total .NET Analyzer featured in the Advisor Zone, Visual Basic .NET provides two options for casting. What you need to know to optimize your applications.


Total Access Startup Eases Deployment Feature

June 9, 2003

Access Advisor Update, Issue 2003 Week 24, features Total Access Startup. Use the tool to launch a database with the appropriate version of Access every time.


SD Times 100 Innovators and Leaders, Recognizes FMS

June 2, 2003

"The SD Times 100 looked for companies which set a direction that developers and the industry followed in 2002... When choosing the SD Times 100, we carefully considered each company's offerings and reputation, as well as the attention and conversion we've heard around the company and its products and technologies, as a sign of leadership within the industry." - Alan Zeichick, Editor-in-Chief of SD Times


Product Review: Total .NET SourceBook

May 29, 2003

"The entire tool is completely intuitive. It's a great training tool and has excellent potential for encouraging development standards. Total .NET SourceBook's simple elegance is impressive." - Andy Clark, Visual Studio Magazine Reviewer


Rave Review: Total Access Analyzer

May 27, 2003

"I have been a fan of FMS since about 1996 when I found your free 3D text add-in for Access 2.0!! I was in college at the time and found your site to be a fantastic resource for learning about Access. I currently use the Total Access Analyzer for Access 2002 here at work. It's awesome." - Dave Totzke, Andrés Wines Ltd.


Microsoft MVP Using Total Access Analyzer

May 16, 2003

"I had four Access 2000 databases with linked tables to SQL Server 2000. Each database had some 60 forms, 80 ODBC linked and/or local tables, 200 queries, and around 100 reports each. I needed to clean up and combine these database front-ends and their respective SQL back ends. I don't know if I would have accomplished this with out using Total Access Analyzer. With the use of this tool I was able to clean up the VBA in all modules (get it to a compiled state). I was able to cross reference every object in the database (down to the field) such that I could find and remove unused objects and or correct errors. The product is great!" - Dave Patrick, Microsoft MVP Windows NT/2000 Operating Systems


Total Access Startup Featured in Advisor Explorer

May 15, 2003

In the current issue of Advisor Explorer, Total Access Startup is featured in the Technology News section.


FMS is a Proud Sponsor of Utter Access.com

May 14, 2003

Visit an incredible forum site for discussion on Microsoft Access, Visual Basic, SQL Server, Office and .NET.


FMS and Microsoft form Access to SQL Server Migration Services

May 12, 2003

The campaign has begun, "FMS has a great history of successfully migrating Access applications over to SQL Server... We knew we wanted a partner with a strong reputation for these service deliveries, so FMS was a natural choice for us." - Adam Carroll, SQL Server Product Manager at Microsoft.


Total Access Admin Featured in Advisor Explorer

May 5, 2003

In the current issue, Total Access Admin is featured in the Technology News section.


Product Award Nomination: Total .NET SourceBook

April 28, 2003

.NET Developer's Journal has listed Total .NET SourceBook as a nomination for their 2003 Reader's Choice Awards.


Total .NET SourceBook for Microsoft .NET

April 24, 2003

"Developers using Visual Studio .NET 2003 have a dependable resource with FMS... Developers using the Total .NET SourceBook for Microsoft .NET will experience greater productivity with a better understanding of the application before deployment." said David Lazar, Director for the Developer and Platform Evangelism Division at Microsoft Corp.


Product Review: Total .NET SourceBook

April 21, 2003

"The mother of all Visual Studio code libraries...they're going beyond code, the first round of downloads included some hints for working effectively with VS .NET and a white paper on macros." - Mike Gunderloy, MCPmag.com


Database Evolution - Guest View In Advisor Magazine

April 17, 2003

Luke Chung, FMS President, discusses database evolution - Microsoft Access in an organization's database strategy.


Product Review: Total Visual SourceBook

April 16, 2003

"Total Visual SourceBook has saved me hours because I don’t have to hunt for older code snippets and am able to employ its vast code library. Total Visual SourceBook can help VB developers keep better track of their code without blowing their budgets." - Brian Kennemer, Builder.com


Get Queries to Run Properly in Access

April 15, 2003

In the May 2003 issue of Access-VB-SQL Advisor, page 24, FMS's own Steve Clark, Project Manager, discusses how to migrate non-normalized data to a normal form in Access.


New Release: Total Access Startup

April 10, 2003

Total Access Startup is now available! Total Access Startup eases the deployment and management of Microsoft Access databases. With Total Access Startup, you can launch your database with the appropriate version of Access every time. Download the FREE Trial today!


Product Feature: Total SQL Analyzer PRO

March 28, 2003

In SQL Server Magazine March issue, Total SQL Analyzer PRO is featured as the software that can document and analyze your database performance and detect design problems on page 9.


Product Features In Visual Studio Magazine Directory

March 24, 2003

In the Visual Studio Magazine 2003 Buyers Guide & Product Directory, both Total .NET SourceBook & Total .NET XRef are featured on page 28. Total .NET Analyzer is featured on page 37. FMS is also featured as a VSIP partner on page 44.


Total .NET SourceBook Featured

March 12, 2003

Stephen Swoyer features Total .NET SourcBook in the Enterprise article.


Product Update: Total SQL Statistics

March 5, 2003

The update patch and new trial for Total SQL Statistics are now available.


SD Times Announces Total .NET Developer Suite

February 28, 2003

In the March 1st issue of SD Times, page 8, Alan Zeichick announces Total .NET Developer Suite. Buy the suite and save big.


Product Feature: Total Access Speller

February 24,2003

In the March issue of Access-VB-SQL Advisor Magazine, page 57, Ken Getz discusses Total Access Speller, an add-in that can help developers catch spelling errors.


Total .NET Developer Suite "Essential Resource"

February 11, 2003

"FMS is providing Visual Studio .NET 2003 developers with an essential resource... Development teams using the Total .NET Developer Suite will experience greater productivity by identifying application development issues before deployment." - David Lazar, Director of the Developer and Platform Evangelism Division at Microsoft Corp.


New Versions for Visual Studio .NET 2003

February 4, 2003

Now available, new versions of Total .NET Analyzer, Total .NET SourceBook, and Total .NET XRef! These 1.1 versions fully support the new Visual Studio .NET 2003 (Everett). Download the FREE trial versions today! Order today and receive BOTH, the 1.1 version (2003) and the 1.0 version (2002)!


New Release: Total Access Admin

January 29, 2003

Total Access Admin is now available! Total Access Admin offers total maintenance control of your Access/Jet databases. Simply start the program, point to your database, and take control.


New Release: Total .NET SourceBook

January 17, 2003

Total .NET SourceBook is the Ultimate Code Library for .NET. Get a jumpstart into .NET with thousands of lines of C# and Visual Basic .NET code. Hundreds of categories, samples, tips, and how-to's make .NET coding a snap.


eWeek Announces Total Access Startup

January 7, 2003

In the January 6, 2003 issue, page14, eWeek announces the new FMS Total Access Startup. The new product sets Access database options and enables distributed deployment of applications. More details on this product coming soon.

Case Study of Total .NET XRef

December 31, 2002

Cross-Reference Tool Eliminates Confusion - Knowing How Code Is Used Makes Changes More Dependable. This case study features BizIntegrity using Total .NET XRef.

"Total .NET XRef is an absolute life saver" - Jeff Lynch, BizIntegrity


Review for Total .NET Analyzer, Code Critic

December 17, 2002

In the January 2003 issue of Software Development, Rick Wayne reviews Total .NET Analyzer on page 20.

"...It's a great way to pick up some of the best practices in .NET coding" - Rick Wayne, Software Development


MSDN Flash Presents Total .NET SourceBook

December 16, 2002

This addition of MSDN Flash announces Total .NET SourceBook in the Products and Technologies section.


Review for Total .NET SourceBook One Place For Everything

December 12, 2002

"Previous SourceBook products from FMS have been very useful, and this looks like another fine addition to the line." - Mike Gunderloy, MCPmag.com


New Microsoft Case Study with FMS Project

December 11, 2002

Omnicom delivers an industry-changing distribution channel for the promotional-products business with Tic Toc Marketplace on the Microsoft site.


Product Review for Total .NET Analyzer by Analyzer That

November 29, 2002

"FMS has a long track record of delivering excellent value to Microsoft Access and VB developers. It looks like they'll be keeping this up with .NET developers." - Mike Gunderloy, MCPmag.com


FMS Initiates Growth Plan in Consulting

November 4, 2002

FMS hires new vice president, Bill Robinette, to take the lead for consulting growth.


Luke Chung Featured in 10th Anniversary of Access

October 24, 2002

Access is now the world's leading desktop database solution, used by millions of people worldwide. Microsoft created a 10 year birthday web page for Access. Another Access addition is the MSDN Access Developer Center. We are proud to announce that three of Luke Chung's technical papers were recently published on that site.


Total .NET Analyzer is Now Shipping!

October 22, 2002

Use Total .NET Analyzer to scan all your projects for errors, performance, security and standard issues.


Visual Studio Wire Features Total .NET Analyzer

October 15, 2002

Visual Studio Wire announces Total .NET Analyzer.


Visual Studio Magazine Reviews Total SQL Statistics

October 7, 2002

In the November issue of Visual Studio Magazine, Total SQL Statistics is reviewed on page 17.

"Total SQL Statistics can help your VB application deliver data quickly from your database to your consumers without having to re-enter or transform it." - John Pearson, Visual Studio Magazine


Total .NET Analyzer Featured On Microsoft VSIP Site

September 30, 2002

Total .NET Analyzer is featured on the Visual Studio .NET Partner Resources main page.


.NET Framework Supported by FMS Products

September 16, 2002

"The FMS Total .NET product line is a valuable resource for Microsoft .NET developers targeting mobile development," said David Rasmussen, lead product manager for .NET mobile developer technologies in the Developer Platform and Evangelism Division at Microsoft Corp.

"Microsoft is pleased to be working with FMS to offer customers an easy-to-use computing experience that will enable developers to take advantage of the dedicated resources of Microsoft .NET."


SD Times Features Total .NET Analyzer

September 15, 2002

.NET Analyzer Checks C#, VB.NET Code by Christina, M. Purpi appears in the Software Development Times, September 15, issue, page 15.


Builder.com Reviews Total Visual CodeTools

September 9, 2002

"I like this product. It has helped me write more readable, maintainable code, and it basically taught me ADO database programming." - Brian Kennemer


Visual Studio Magazine Features Total SQL Statistics

September 6, 2002

In the October issue of Visual Studio Magazine Total SQL Statistics is featured in the Product Listings section, page 21.


Visual Studio Magazine Reviews Total .NET XRef

September 5, 2002

In the October issue of Visual Studio Magazine Total .NET XRef is presented in the First Looks section, page 19.

"One nice feature of XRef is its ability to find any object," said Dianne Siebold. "XRef is useful for speeding up development in enterprise projects."


MSDN Flash Presents Total .NET Analyzer

September 4, 2002

Volume 6, Number 9 announces Total .NET Analyzer in the Products and Technologies section.


MSDN Subscriptions Are Available Here

September 3, 2002

Now you can join the Microsoft Developer Network at a savings. Subscriptions and renewals are available today.


C/C++ Users Journal features Total .NET XRef

August 27, 2002

In the New Products section: FMS Releases Total .NET XRef, August issue, page 57.


Smart Access Reviews Total Visual CodeTools

August 19, 2002

"If you've never been good about coding standards, or your good intentions are sometimes sacrificed when you're working in crunch mode, then you owe it to yourself to check out Total Visual CodeTools, a great set of coding tools." - Danny Lesandrini, August issue, page 17-18.


Windows Developer Features Total SQL Analyzer PRO

August 15, 2002

New product announcement in the August issue, page 52.


Microsoft Office Solutions Magazine Reviews Total Access Speller

July 30, 2002

"It's entrepreneurship at its best: A company listens to users' complaints about a weakness in a popular program, and then the company provides a solution. That's exactly what FMS, Inc. has done for Microsoft Access database developers with Total Access Speller." - Faithe Wempen, August issue, page 37-38.


Advisor Magazine Reviews Total Access Speller

July 18, 2002

"If you're worried about the spelling on your Access database interface objects, check out FMS Total Access Speller...you'll have no problem figuring out how to use the program." - Crag Bobchin, Contributing Writer, August issue, page 38-39.


Advisor Magazine Publishes Rob Mastrostefano

July 17, 2002

The August issue contains Create a Page Indicator Component on page 18. Rob Mastrostefano is a senior system analyst with FMS and a member of the consulting team that develops custom software solutions.


Advisor Magazine Reviews Total .NET XRef

July 16, 2002

"I found this is a tool of the same FMS quality developers have come to rely on...it sure is nice to have in my toolbox." - Thomas Wagner, August issue, page 38.


Smart Access Features Total Access Detective

June 19, 2002

"If you're working on a whole bunch of databases and need help keeping track, this one is for you." - Smart Access eXTRA, Issue 3.6


Microsoft Office Solutions - Total Access Components

June 5, 2002

Total Access Components for Access 2002 is featured in the June issue of Microsoft Office Solutions Magazine, page 6, in the Toolbox section.


MCP Magazine Features Total Access Detective

June 5, 2002

Mike Gunderloy provides a nice review of Total Access Detective 2002.


Advisor Magazine Features Total Access Detective

June 3, 2002

Track changes in Access 2002 with Total Access Detective - June 2002 issue.


Windows Developer Announces FMS Total .NET Line

June 1, 2002

The Windows Developer Magazine, June 2002 issue, announces the entire FMS Total .NET product line.


Pinnacle Publishing Adds Total .NET XRef

May 31, 2002

Pinnacle Publishing adds Total .NET XRef to their .NET Developer Store.


Total SQL Analyzer PRO Reviewed

May 23, 2002

Sid Singer of Database Developers Group reviews Total SQL Analyzer PRO. "I found the detailed listing of scripts for all database objects, along with issues for each, to be an invaluable documentation guide to the database design features. Another favorite is the dependencies report, which illustrates all the relationships among the objects in the database." - Sid Singer, Database Developers Group


SQL Wire.com Announces Total SQL Analyzer PRO

May 17, 2002

Total SQL Analyzer PRO - the enhanced version of its predecessor.


MSDN Magazine Announces FMS .NET Products

May 16, 2002

In the June 2002 issue, section "NEW STUFF", page 11 - FMS rolls out five new developer products for Visual Studio .NET.


dotnet infowire.com Announces Total .NET XRef

May 15, 2002

Dotnet Infowire.com announced Total .Net XRef.


asp.netPRO Magazine Announces FMS .NET Products

May 14, 2002

FMS offers five new developer products for Visual Studio .NET. - asp.netPRO May 2002 issue, page 56


Total SQL Analyzer Gets 5 Star Review

May 13, 2002

"Total SQL Analyzer is a unique tool with a great price...Building on 15 years of experience, FMS continues to deliver outstanding bang-for-the-buck development tools. I highly recommend this product." - Thomas Wagner, asp.netPRO Magazine, Star Review, June 2002 issue, page 56.


MCP Magazine Reviews Total .NET XRef

May 1, 2002

"The end result is a tool that you can just use, as if it had been built in all along. And after a while you'll wonder how you did without it." - Mike Gunderloy, MCPmag.com


Windows Developer Magazine Announces FMS Products

April 29, 2002

Total Visual Agent, Total Access Components, and Total Access Statistics were listed in the "New Products" section of Windows Developer Magazine, May 2002 issue, page 68.


Total Access Analyzer Reviewed

April 25, 2002

"Total Access Analyzer is the most thorough solution for completely documenting Access databases." - Mike Gunderloy, Smart Access eXTRA, Issue 3.2


VBXtras Publishes Dan Haught's Article

April 19, 2002

Creating High-Resolution Times with Total Visual SourceBook.


Advisor.com Features Total Access Detective

April 18, 2002

Track changes in Access 2002, as well as discrepancies in different versions of your database.


C/C++ Magazine Announces Product Release

April 15, 2002

In the May 2002 issue of C/C++ Magazine, Total Visual Agent is announced on page 59, in the "New Products" section.


asp.net PRO Magazine Published Dan Haught's Article

April 11, 2002

In the April 2002 issue of asp.net PRO Magazine, Designing Commercial Web Services: Part 2, Versioning and Client Support with the .NET Framework on page 52, in the "asp:feature" section.


Visual Studio Wire.com Posted Total .NET XRef Release

April 10, 2002

Total .NET XRef - New Software is now available!


Total .NET XRef Now Available

April 4, 2002

Cross reference code on demand with Total .NET XRef.

"It is blazingly fast...I was completely astonished at the speed of this tool." - Thomas Wagner, eTechPartner, Inc.


SQL Server Magazine, April Issue

April 3, 2002

Analyze Stored SQL Server Data, page 12 - Total SQL Statistics


Total Access Analyzer Reviewed

April 2, 2002

"Total Access Analyzer remains one of the most essential add-ins on the market for the serious Access developer." - Mike Gunderloy, Microsoft Online Certified Professional Magazine


Smart Access eXtra issue 3.3, from Pinnacle Publishing

March 27, 2002

Announces Total SQL Analyzer PRO, Total Access Analyzer, Total Access Detective and Total Visual Agent are all available.


Total SQL Analyzer Reviewed

March 19, 2002

"I can envision how great this tool would be to provide clients with detailed documentation of their servers and databases. Overall, TSA fills a glaring hole in the existing SQL Sever toolset and is easy to use." - Dianne Siebold, Visual Studio Magazine


SQL Server Magazine March Issue

March 18, 2002

New Product, Developer Tool, page 10 - Total SQL Statistics


DNJ Post Total .NET XRef to their Site

March 14, 2002

Visualize your C# and VB.NET code.


Microsoft Office Solutions Magazine March Issue

March 13, 2002

In the "Tool Box" section, page 6. Two new products, Total Access Speller and Total SQL Statistics are featured.


Total Visual Code Tools Reaches MSDN April Issue

March 12, 2002

Define Enterprise-wide Coding Standards.


Total SQL Analyzer PRO is Available

March 11, 2002

The Total SQL Analyzer PRO version is now available. To see what's new, visit Total SQL Analyzer PRO.


All 2002 Access Products Are Now Available

March 11, 2002

Our Access 2002 products are now available, including Total Access Analyzer!


Total Access Detective for Access 2002 is Shipping

March 6, 2002

Find differences between objects and databases. Great for multi-developer and multi-version environments.


Total Access Speller Reviewed

March 6, 2002

"Some tools save you time; some save face. The way I figure it, avoiding personal embarrassment in front of my clients makes this product worth the price." - Danny J. Lesandrini, Pinnacle Publishing.com, March 2002 issue.


FMS Products Win Awards from Visual Studio Magazine

March 4,2002

Visual Studio Magazine Reader's Choice Merit Awards for Total VB Statistics - Data Analysis Tool and Total Visual Agent - Middleware and Data Connectivity.


Total Visual CodeTools Reviewed

February 28, 2002

"With Total Visual CodeTools, you can slip standards in as part of a productivity tool set - and expect that people will actually conform. Also, worth a look if you ever expect to go back and try to maintain your won code. Don't overlook the Help file either - rather than just describing the product, it's also got a long and useful section on VBA best practices." - Mike Gunderloy, Smart Access eXTRA, issue 3.2.


Alison Balter's New Book is Out

February 27, 2002

Alison Balter's Mastering Access 2002 Desktop Development

"The Total Visual SourceBook is any developer's best friend. The code library alone is worth many times the price of this tool. This tool goes a long way toward promoting reuse and consistency within a development environment." - Alison Balter


Total Visual SourceBook Reviewed

February 19, 2002

"The thing is, there are many times where code must be used to make one’s application do something different and that is when you will really appreciate the brilliance of Total Visual Sourcebook." - Graham J. Hadlington, Helping Hands, UK


VSLive Exhibitor

February 14-16, 2002

San Francisco, CA


Five New Products for Visual Studio .NET

February 13, 2002

"Microsoft, in combination with FMS is delivering an easy-to-use computing experience that will enable customers to take advantage of the next generation of the Web," said David Lazar, group product manager for the Developer and Platform Evangelism Division at Microsoft Corp.
"The FMS product line for Microsoft .NET will be an extremely valuable set of products for our mutual customers."


First .NET Preview Version - Total .NET XRef

February 12, 2002

It is here! Download this incredible preview version today and put it to work on your Visual Studio .NET projects.


Total Access Statistics Reviewed

February 6, 2002

Microsoft Online Certified Professional Magazine reviews Total Access Statistics for Access 2002.

"If you're doing any sort of scientific or engineering number-crunching and your data is available to Access (either as native Jet data or as linked tables), TA Statistics can save you a bunch of work." - Mike Gunderloy, MCP Magazine Newsletter


Total Visual Developer Suite Now Available

January 30, 2002

The Total Visual Developer Suite includes Total Visual SourceBook and Total Visual CodeTools, with new support for Access 2000/2002, Office 2000/XP and Visual Basic 6.0


Total Access Speller Reviewed

January 29, 2002

Smart Access eXTRA issue 3.1.


Four New .Net Programs That Significantly Enhance .NET

January 29, 2002

Developers can create applications faster, analyze and cross-reference code, simplify development efforts, and improve the quality of their results with our productivity products.


Total Visual SourceBook Now Available

January 28, 2002

New Support for Access 2002, new code for ASP and more!


Total Visual CodeTools Now Available

January 22, 2002

Total Visual CodeTools for Access 2000/2002 and Visual Basic 6.0 is now available.


SD Times Newspaper Writes On Total SQL Statistics

January 15, 2002


asp.net PRO Magazine Published Dan Haught's Article

January 15, 2002

Designing Commercial Web Services: Part 1, Security and Flexibility with the .NET Framework.


Total Access Speller Now Available for Access 2002

January 14, 2002

You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.


Total Access Analyzer Reviewed by Swynk.com

January 10, 2002


Total Visual Agent Reviewed by Microsoft Online Certified Professional Magazine

January 9, 2002

"Jet is pretty well ubiquitous for those of us who use Microsoft operating systems, but it's often viewed as a toy database. By using Total Visual Agent, you can add professional data-integrity features to your Jet-based applications. The peace of mind and the safety of critical backups make it worth spending the money." - Mike Gunderloy, Microsoft Online Certified Professional Magazine


Total SQL Statistics Listed on SQL WIRE.COM

January 2, 2002

Total SQL Statistics VB.NET Advisor Tech News

December 31, 2001


Total Access Speller Now Available for Access 2000

December 27, 2001

You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.


Total Access Speller Now Available for Access 97

December 24, 2001

You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.


Total Access Memo Now Available

December 21, 2001

New Support for 2002! Robust and Professional rich text formatting - Now with full justification of text!


Total SQL Analyzer Gets Software Spotlight

December 12, 2001

Automate the documentation of SQL Server using Total SQL Analyzer. SQL Sever Performance.com gives Total SQL Analyzer the Software Spotlight!


Total SQL Analyzer Gets Another 4 Star Review

December 12, 2001

"Total SQL Server Analyzer is an invaluable tool that can save you time in preparing documentation, whether for Business Analyst, customers, or for disaster recovery preparedness. The documenting engine outputs data that is gold to me because I don't have to spend the days it would take to generate it. It lets me spend those days performing better uses for my time." - Brian Knight, SQL Server Central.Com


Total SQL Statistics Now Available

December 11, 2001

Powerful Number Cruncher for SQL Server and .NET Ready!


Total Access Statistics Now Available

December 5, 2001

New Support for 2002! The most powerful data analysis program for Microsoft Access.


Total Visual Agent Now Available

December 4, 2001

Automate maintenance chores for your Access/Jet databases: Automate backups, compact/repairs, repetitive tasks, and much more.


Total Access Components Now Available

November 28, 2001

27 ActiveX controls written specifically for Microsoft Access: supercharge you forms and reports, and simplify programming.


DNJ Reviews Total SQL Analyzer

"If you want to keep your database running efficiently, Total SQL Analyzer could provide the answer." - Kay Ewbank


Smart Access Reviews Total Access Analyzer 9.5

November 2001

"This is one Access utility that's worth the money", said reviewer Danny Lesandrini.  


On the Radio

October 27, 2001

On the October 27 radio broadcast of "Let's Talk Computers", Luke Chung, FMS President, discusses changes in the computer industry and the 15 year anniversary of FMS.


Total SQL Analyzer Gets 4 Stars

"I hate documenting things as much as anyone, but I recognize the value and try to spend time working on it. I was excited to see a product that would ease the burden of documentation." - Steve Jones, SQL Server Central.com


Microsoft Selects FMS as Visual Studio Partner

FMS is selected by Microsoft as a Visual Studio Partner.


FMS Now Offers ESD

September 28, 2001

FMS, Inc. has announced the availability of ESD, Electronic Software Distribution, for its line of award winning products. Through ESD, customers no longer have to wait for their FMS product packages to be mailed to them but can quickly purchase and safely download them electronically. Customers will also save money by avoiding shipping costs – especially important for those overseas who find themselves frustrated with customs expenses.

For more information, visit FMS offers Heightened Convenience with ESD!


FMS President Gives Radio Interview for Entrepreneurs Group

Entrepreneurs Tour of America. Find out more about the man who started it all, and how FMS was built slowly and carefully over 15 years. No overnight, get rich quick scheme here!

You will need a FREE Real Player 8 Basic to hear this radio show interview.


FMS Wins Advisor Magazine Editors' Choice Awards

Total Access Analyzer, Total Access Components, and Total Visual CodeTools won Gold Editors' Choice Awards.

Total Access AnalyzerAward

Best Access Add-In

Total Access ComponentsAward

Best Access Add-In

Total Visual CodeTools
Award

Best Visual Basic Add-In


angryCoder.com Reviews Total SQL Analyzer

"It's greatest strength lies in preserving a set of document snapshots for database object comparison over time." - Danny J. Lesandrini


Total SQL Analyzer Is Now Shipping!

The world's first professional documentation and analysis program for Microsoft SQL Server. Now you finally can take control of SQL Server with Total SQL Analyzer.


New FMS Products For Microsoft Office XP

May 31, 2001

FMS is pleased to announce support for Microsoft Office XP and Access 2002. FMS currently offers an award winning family of eight products targeted for Access and Office users and developers.


Total Visual Developer Suite 2000 Reviewed

March 2001

"Every time I look at the package with the little blue-and-green tag reading "What's your time worth?" I think about the thousands of lines of ready-to-use code that come with it. I must say that on more than one occasion Total Visual SourceBook has made the difference between a marginally profitable project and a soundly profitable one. I cannot imagine any VB programmer who could live without this excellent tool." - Thomas Wagner of MS Office Deployment and Development

Total Visual Developer Suite 2000


Microsoft Office Deployment and Development Conference

April 8-12, 2001

Orlando, FL
Exhibitor
Speaker - Luke Chung, FMS President, answers Access questions and demonstrates FMS products for Access


VBPJ 2001 Readers Choice Award

Total Visual Agent 2000 voted the Readers Choice Award for Best Middleware & Data Connectivity.


We Want Your Input

Our continued efforts to improve are still strongly focused on customer feedback. Please take a minute to compete our new purchase survey and tell us how we are doing.


VSLive/VBITS

January 13-20, 2001

San Francisco, CA
Exhibitor
Speaker at Tools Track


FMS Visits NYC

January 8, 2001

Access SIG, New York, NY
Speaker, Luke Chung, President.

For more information, visit our Upcoming Events page.


Total ZipCode Database Released

January 2, 2001

The entire USPS 5-digit zip code database with corresponding city and state names. Includes monthly subscription updates. Enter a zip code and go!

Introducing the FMS Community Newsgroup

Get involved in the community. Do you have a question or need product support? Discuss the solution while you gain knowledge on the FMS Community Newsgroup site. We've improved everything to better communicate with you.


VB Tips & Tricks Reader Choice Awards

Total Visual SourceBook 2000 was voted "Most Popular Programming Component" while Total Visual CodeTools 2000 received Straight A's in its categories.

Learn more about our Award Winning Products!


Microsoft Access Dev Con 2000 Pinnacle Awards

FMS collected seven awards during the DevConnections 2000 conference in New Orleans. Jointly sponsored by DevConnections and Pinnacle Publishing, these awards recognize excellence in third party tools and are chosen by developers like you who really use and know the tools.

Learn more about our Award Winning Products!


On the Radio

On the August 12 radio broadcast of "Let's Talk Computers", Luke Chung, FMS President, discusses FMS and ways to develop Visual Basic applications more efficiently with FMS products. 


Access 2000 Suites Released

Serious Access developers should get our award-winning products in suite bundles to save time and money! Now available for Access 2000.


Visual Basic Suites Released

Visual Basic developers can now get our award-winning products in money saving bundles! Designed for individual developers and development teams, these suites will save you time and headaches!


FMS President takes the reins at Young Entrepreneurs' Organization

FMS President Luke Chung is now serving as president of the Washington, DC chapter of the Young Entrepreneurs' Organization (YEO). YEO is a global, non-profit, educational organization that helps its 3500+ members build upon their successes through an array of learning and peer-to-peer support opportunities.


Total Visual CodeTools 2000 Released

Increase your productivity and let your entire development team share and enforce a consistent set of coding standards. Supports Access/Office 2000 and Visual Basic 6.0


Total Visual SourceBook 2000 Released

The Ultimate Code Library for Developers, Teams and Enterprises! Supports Access/Office 2000 and Visual Basic 6.0


Total Access Components 2000 Released

The only collection of custom controls designed specifically for Access. Easily add new power and functionality to your Access applications.


Total Access Analyzer 2000 Released

Winner of every Best Access Add-in award since 1994. Total Access Analyzer 2000 is now available.


Total Visual Agent 2000 Reviewed

Microsoft Office and VBA Developer Magazine "It's not very often that one runs into a product that is useful to so many members of an IS team. A network administrator can use it, because data backup is typically something assigned to this person; a corporate developer or DBA can use it to maintain Jet databases in their optimal state; and a consultant can use its e-mail notification capabilities. It's so easy to run that, in a pinch, even a power user can use it. Total Visual Agent is a real find, a rare combination of ease of use, and "bang for the buck." In the end, no other competitor even comes close!" - Thomas Wagner, MS Office and VBA Developer

Total Visual Agent 2000
FMS' Database Maintenance Tool
May 2000, MS Office & VBA Developer, pp. 58-59.


Total Access Memo 2000 Released

Only Total Access Memo 2000 gives you the power to add full formatting to your rich text data! Our super-easy data binding means the you can integrate rich-text right into your existing tables.


Total Access Statistics 2000 Released

The most powerful data analysis program for Microsoft Access is now available for Access 2000. Perform a wide range of statistical analysis on your databases.


Total Access Memo 2000 Recommended by Microsoft

Microsoft reports a bug in Access 2000 that they say can be resolved by using FMS' Total Access Memo 2000! According to Microsoft, you cannot see the contents of an embedded Microsoft Rich TextBox ActiveX Control when you Print Preview a report in Access 2000. However, FMS has a RichText control available that does not result in the behavior described in the article.

1999 VBXTRAS Thunderbolt Awards

Total VB SourceBook, is still receiving recognition and awards from the VB community! Total VB SourceBook has received the VBXTRAS Best Source Code Library and the Best Collection of General Purpose Components Awards. Each year readers of VBXTRAS -- a leading magazine for Visual Basic® programmers -- select the award-winning products because they’re the most intriguing, innovative, and promise the best value for Visual Basic developers. Awards


Visual Developer MagazineTotal VB SourceBook Reviewed

Total VB SourceBook received another glowing review. This time from Visual Developer magazine.

"Total VB SourceBook calls itself “The Ultimate Code Library for Visual Basic”, and from what I can see it lives up to that claim....

"Anyone starting out with VB project needs Total VB SourceBook. While more experienced programmers will already know many of the techniques and procedures in this database, everyone will find something to use. The ability to add and index your own procedures in a multi-programmer environment makes this a tool no VB programmer should be without" - Matt Hart, Visual Developer Review


Visual Basic Programmer's Journal Total VB Statistics Reviewed

See what the experts are saying about our statistical analysis program for Visual Basic in the May issue of VBPJ or see full text of the article online.

"If you are looking for a small but powerful statistical calculation engine, Total VB Statistics can help. It is flexible and easy to use, and best of all, it writes the code for you." - Rama Ramachandran, VBPJ Review


Total VB SourceBook Wins the 1999 VBPJ Readers' Choice Award

Total VB SourceBook, FMS' debut Visual Basic product, is already receiving recognition and awards from the VB community! Total VB SourceBook received the highly coveted Visual Basic Programmer's Journal (VBPJ) Reader's Choice Award. Each year readers of VBPJ -- the leading magazine for Visual Basic® programmers -- select the award-winning products because they’re the most intriguing, innovative, and promise the best value for Visual Basic developers.

Take a look at the Ultimate Visual Basic Code Library and Code Repository...Click here!

Total VB SourceBook
1999 VBPJ Readers' Choice Award Readers' Choice
Award


Total Access Detective Reviewed

Total Access Detective was reviewed in the March 1999 Denver Access Area User Group Newsletter. Click here for full text of the article!

"Total Access Detective is valuable for those times when you have two or more versions or copies of the same database and you are not sure which one is the latest version. This program is a must have for those times when you have two or more people working on the same project, it takes the confusion out of trying to determine which changes or updates are the correct ones."


Total VB SourceBook Reviewed

Read the rave reviews Total VB Visual Basic SourceBook has received:

"A programmers dream!...all code in the SourceBook is completely reusable, with royalty-free distribution rights. And its perfectly commented too - just the right information for beginners and advanced developers alike...Smart, innovative and easy-to-use - this product is full of real-world solutions that you can't find anywhere else...and invaluable addition to anyone's development toolkit. A must-have!" -- WinPlanet Review

Visual Basic Programmer's Journal Total VB SourceBook
Spring 1999 Buyers Guide, VBPJ, page 68.
WinPlanet Logo
stars
4˝ out of five stars!
Total VB SourceBook
January 1999, WinPlanet Online Review.
Visual Basic Programmer's Journal Borrow Code from the Library
November 1998, VBPJ, page 15.
Total VB SourceBook 5.0.1 for Microsoft Visual Basic
August 14, 1998, Visual Programming++.

FMS Wins 13 Access-VB-Office Advisor Reader's Choice Awards!

Seven of our add-ins won thirteen awards in the 1998 Access-Office-VB Advisor Readers Choice Awards. Access-Office-VB Advisor is the premier magazine for Microsoft Access. With this clean sweep of the majority of the Microsoft Access categories, FMS is clearly established as the leading 3rd party product provider for Access. The following is a list of our award winning products:

Total Access Analyzer
Best Access Add-In - Gold medal
Best Debugging Tool - Gold medal
Best Documentation Tool - Gold medal
Total Access Agent
Best VB Add-In - Silver medal
Total Access CodeTools
Best Access Add-In - Silver medal
Total Access Components
Best ActiveX Control - Gold Medal
Best Interface Design Tool - Gold Medal
Total Access Detective
Best Debugging/Testing Tool - Silver Medal
Total Access SourceBook
Best Office Add-In - Gold Medal
Best Source Code Library - Gold Medal
Best Access Add-In - Silver Medal
Total Access Statistics
Best Business Product - Gold Medal
Team Access
Best Version Control Tool

Rave Reviews!

Check our our online reviews, and see what the critics are saying about our products.

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, Trainer, Consultant

 

Questions

 

 

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, Trainer, Consultant

 

Questions

 

 

Free Product Catalog from FMS