Recent News from FMS

Visit our FMS Development Team BlogBlog and Facebook for Microsoft Access Products from FMS Facebook page for our latest news. For past FMS news, check out our News Archive and Legacy Press Releases.


July 13, 2020

Office 365Microsoft has created the Monthly Enterprise Channel that provides users with new Office features each month on a predictable release schedule.

Our FMS Development Team has created a page with step by step instructions on how to change your Office 365 update cycle to the Monthly Enterprise Channel.

For more information, visit How to change the Office 365 update cycle to the Monthly Enterprise Channel.

American Express Enroll by July 26, 2020
Spend by September 20, 2020

American Express has a special offer for card members! If you are an American Express Card Member, enroll your eligible Card by 7/26/2020 to get $5 back after you make a single transaction of $10+ when you Shop Small by 9/20/20, up to 10x to show support for your fellow Small Businesses like FMS, Inc!

For more information and to enroll, visit AMEX Supporting Small Business with Shop Small.

Portland Oregon Microsoft Access User Conference

**UPDATE**

July 3, 2020

Due to the growing concerns around the spread of the COVID-19 virus, the PAUG 2020 conference has been cancelled. There will be a survey sent out to gauge the interest of a high-quality Virtual Conference for this Fall. To receive the survey, make sure you're on the Access Day Email List.


Portland Oregon Microsoft Access User ConferenceOctober 10 - 12, 2020

Portland, Oregon

The annual Portland Access User Group Conference will be returning to the Conference Center at Silver Falls. The peaceful, natural setting of Silver Falls State Park lends itself to a climate that fosters learning and creativity.

The weekend event will bring together some of the top Microsoft Access developers, enthusiasts, and Access development team members.

Registration will begin on June 10 - 11, 2020. To find out more, check out the Portland Access User Group website.

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

Microsoft Access 2016 Database Documenter


Total Access Emailer 2016
Send Personalized Emails from Microsoft Access!

Microsoft Access Email Blaster


Microsoft Access to SQL Server Upsizing

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

Denver Area Access Users GroupJuly 16, 2020

Denver, Colorado

6:30 PM (Mountain Time Zone)

FMS President Luke Chung has been invited by the Denver Area Access Users Group to give an online presentation on "Access Remote App".

Remote Desktop and RemoteApp let your users run Access applications without having to installing anything on their local machine. That includes Access, the database, and any related programs. It lets users run the program across the network or Internet, from their PC or even a Mac. Luke Chung will demonstrate different approaches depending on whether the host is internal or in the cloud, and for backend databases in Access and SQL Server.

To find out more, visit the Denver Area Access Users Group website.

Microsoft Access 2019June 24, 2020

The Microsoft Team has announced that the Decimal Field issue has been fixed in all channels.

  • Current Channel - Version 2005, Build 12827.20470
    (User may need to force a manual update to get the version.)
  • Current Channel (Preview) - Version 2006, Build 13001.20198

For more information on the issue, visit Microsoft's support page Access VBA/DAO code may crash or report incorrect data for Decimal Columns.


June 18, 2020

There’s a new build update (13001.20198) released on June 18, 2020 for Current Channel (Preview) that has been reported to solve the issue related to using SQL/VBA to write to a Number Data type with a Decimal field size.


June 8, 2020

Ebo Quansah from the Microsoft Access Team announced problems with decimal fields using the current Microsoft Access Build 12827.20010 that was released with the Monthly cycle. Decimal fields are not commonly used in Access database files, but they are used in linked SQL Server tables.

If you manipulate Decimal fields (Access DataType=Number/FieldSize=Decimal, or SQL DataType=Decimal) using DAO (Data Access Objects), you might have identified your app crashing.

Visit our blog post, Decimal Field Problems in Micrososoft Access Build 12827.20010 for more details on the issue.
Fixes and workarounds will be posted once announced.

FMS NewsletterJune 15, 2020

Our June 2020 newsletter has been published with news on the enhancements for Microsoft Access, SQL Server Express 2019 is now available. Information on an issue that does not allow Access to recognize the Identity Column in a linked SQL Server table. FMS President Luke Chung's presentation on "Remote access to Access".

If you did not receive the newsletter through email, you will find it here: FMS June 2020 Newsletter

Remote DesktopRemote access to Access

May 15, 2020

FMS President Luke Chung was a presenter at the Virtual Microsoft Access DevCon 2020 in Vienna, Austria on April 23, 2020. He gave a presentation called "Remote access to Access", which is available for everyone to watch.

Remote Desktop and RemoteApp let your users run Access applications without having to installing anything on their local machine. That includes Access, the database, and any related programs. It lets users run the program across the network or Internet, from their PC or even a Mac. There are different approaches depending on whether the host is internal or in the cloud, and for backend databases in Access and SQL Server.

Special thanks to Microsoft Access MVP Karl Donaubauer, who hosted the fourth annual Access DevCon and made it an online event during the COVID-19 lockdown.

Virtual Access DevCon 2020

Have any suggestions or comments? Head to our blog post Video: Remote access to Microsoft Access from DevCon Austria and leave us your feedback!

Microsoft SQL Server May 13, 2020

We've updated our Microsoft SQL Express page with information on SQL Server Express 2019!

For local PC, small databases, and less critical situations, Microsoft offers a limited version of SQL Server called SQL Server Express. SQL Server Express can be downloaded for free and installed on your local PC.

For more information, visit Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads.

Access DevCon in Vienna, AustriaApril 23 - 24, 2020

Due to the restrictions on movement and travel in Europe, Microsoft Access MVP Karl Donaubauer announced the FREE Virtual Developer Conference on April 23 and 24, 2020. FMS President Luke Chung was a speaker and gave a presentation on "Remote Access to Access".

To watch the presentations and download the slides and demo files, visit Virtual Access DevCon 2020.


April 25 - 26, 2020

Access DevCon in Vienna, Austria Fellow Microsoft Access MVP Karl Donaubauer will be hosting the fourth annual Access DevCon in Vienna, Austria.

The DevCon means two days packed with presentations by experts from Europe and the USA, an opportunity to get the latest news on Microsoft Access, to see advanced techniques and thrilling real world applications as well as to meet and chat to colleagues from all over the world.

To find out more, check out the Access DevCon website.

**UPDATE**

Tuesday, March 17, 2020

Due to the Coronavirus (COVID-19) the Microsoft Store at Tysons Corner Mall is now closed until the pandemic has passed. For that reason, the Washington DC Microsoft Access Meetup for Wednesday, March 18, 2020 has been cancelled. For more information and updates for future evens, visit Washington, DC Microsoft Access Meetup.


Washington DC Access User GroupWednesday, March 18, 2020

7:00 PM

Microsoft Store in Tysons Corner Center

The Washington DC Access User's Group will hold their Quarterly Meeting at the Microsoft Store in Tysons Corner Center. Join fellow DC Access members as they share their experiences with Microsoft Access and the solutions to different Microsoft Access questions.

For more information and to RSVP, visit Washington, DC Microsoft Access Meetup.

**UPDATE**

March 3, 2020

Access DayDue to the growing concerns around the spread of the COVID-19 virus, J Street Technology has decided to cancel Access Day. At this time, there is no plan to reschedule this event. Paid registrants will receive a full refund of their conference fees within the week. For more information and updates for future events, visit J Street Technology Access Day Events.


March 19, 2020

Microsoft Main Campus, Redmond, WA

Join FMS President Luke Chung for a one-day conference hosted by J Street Technology on the most popular desktop database application development platform - Microsoft Access! Meet international respected presenters, including Microsoft Access MVPs, book authors, and members of the Access development team at Microsoft.

Luke Chung will be giving a presentation on Power Apps for Access Developers. For more information and to register, visit J Street Technology's Access Day!

Microsoft AccessFebruary 25, 2020

An important announcement from the Microsoft Access team addresses the problems with connecting to Access ACCDB databases from other programs.

If you have Office 365, or click-to-run versions of Access 2016/2019 Consumer installed, you no longer need to install ACE to support external programs! FMS President Luke Chung published a blog post about this exciting announcement! If you have any comments or questions, visit Breaking ACE out of the Bubble!

November 12, 2019

A set of Microsoft Office security updates released on November 12, 2019 causes Access databases to fail when it runs Update Queries to modify data. An error like this appears when the query is run:

Query is Corrupt

Query is CorruptIt doesn’t matter if the query is against a table in the current database, a linked table, or a linked SQL Server table. If the Access database engine is processing the UPDATE query, the error occurs.

In addition to Microsoft Access, other programs that update Access databases may also be affected. That includes Excel, PowerPoint, Word, etc. and programs written in Visual Studio .NET, VB6, and web applications.

Our team at FMS created a page with the workarounds and fixes for this issue, visit our Microsoft Access Update Query is Corrupt page for more details.

Visit our Blog post to view the comments and suggestions from fellow Microsoft Access Users about the Microsoft Access Query is Corrupt issue.

FMS Newsletter

Our November newsletter has been published with news on the security update released by Microsoft that caused Microsoft Access queries to fail. FMS is celebrating 33 years in business, and we've added some tips and tricks for Microsoft Outlook and Office 365.

If you did not receive the newsletter through email, you will find it here: FMS November 2019 Newsletter

Decades of Quality ResultsOctober 26, 2019

FMS, Inc is celebrating its 33rd 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.

Office 365October 21, 2019

Our team at FMS has written step-by-step instructions on how to create Email Aliases and how to Forward Microsoft Office 365 message to another mailbox.

We hope this helps! If you have any suggestions or comments, head to our blog post!

For more information, visit Email Aliases and Forwarding Microsoft Office 365 Messages to Another Mailbox.

Portland Oregon Microsoft Access User Conference

September 28 - 30, 2019

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.

FMS President Luke Chung gave a presentation at this year's conference on how to "Use Remote App to Host Access Desktop Applications in the Cloud".

Check out some of the photos that were taken at the 2019 Portland Access User Group conference! For more information on what went on at the 2019 conference, visit the PAUG conference web site.

Portland Oregon Microsoft Access User Conference

Netherlands Access Developer Day 2019

September 14, 2019

Amsterdam, Netherlands

FMS, Inc was a proud sponsor of the 2019 Netherlands Access Developer Day. The event brought together Access Experts from all over the world.

FMS President Luke Chung gave a presentation on the Microsoft Access Database Evolution from the Desktop to the Cloud.

Check out some of the photos that were taken at the Netherlands Access Developer Day! For more information about the 2019 conference, visit Netherlands Access Developer Day 2019.

Netherlands Access Developer Day

FMS Newsletter

Our September newsletter has been published with news on our new update for Total Access Analyzer 2019, 2016, 2013, 2010 and 2007. We've added links to our updated web pages on Microsoft Access Shortcut Keys for Data Entry/Navigation and Inheriting Legacy Microsoft Access Databases.

FMS has started sponsoring the Portland Oregon Access User Group on Meetup and FMS President Luke Chung will be speaking at two upcoming Microsoft Access conferences!

If you did not receive the newsletter through email, you will find it here: FMS September 2019 Newsletter

Total Access Analyzer

August 2019

New updates for Total Access Analyzer are available for Microsoft Access 2019, 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 430+ 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

  • Ribbon Documentation
  • Data Macro Analysis
  • SQL Cross-Reference and Validation of Subform References
  • New Errors and Suggestions
  • Report, View Explorer and Quick Documentation Enhancements
  • About Box has Check for Updates
  • Revised User Manual and Help File
  • Improved User Interface
  • and more...

For more information, visit:

Download the Free Trial to experience it for yourself.

Microsoft Most Valuable Professional

Microsoft recognized FMS President Luke Chung as a Microsoft MVP for the eighth 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

Portland Access User Group

FMS is sponsoring the Portland Microsoft Access User Group on Meetup! This group is dedicated to Microsoft Access and meet every month to share their experiences and answer questions about Access.

Meetup is an online community that you can join for free and receive notifications from the group. If you are close to Portland, Oregon, we invite you to join them!

FMS Newsletter

Our March newsletter has been published with news on our new papers including a useful Microsoft Access tip on copying a command button on a form without losing its picture, a SQL Server paper on replacing server logins with database users, and addressing SQL Server security holes on Azure.

We have included a link to download all the free Microsoft Access Runtime Distributions and a support page on how to tell if you're using Microsoft Access 2016 or 2019 and much more!

If you did not receive the newsletter through email, you will find it here: FMS March 2019 Newsletter

Command Button with Graphic

Microsoft Access forms allow you to add pictures to command buttons. A helpful way to visually identify buttons. Unfortunately, when you want to copy and paste the button, the new button doesn't have the picture.

Our team discovered an easy way to modify the original command button so that you can copy and paste it with its picture! There are also steps on using your own graphic files.

To read the full step by step instructions, visit the Microsoft Access Form Tip: Copy and Paste a Command Button without Losing its Picture.

Microsoft AccessRedmond, Washington

Thursday March 21, 2019

In conjunction with the Microsoft MVP conference, FMS President Luke Chung is participating with Access Day in Redmond, Washington! It is hosted once again by J Street Technology!

Registration information is available at Access Day 2019.

Washington DC Access User GroupMicrosoft Store in Tysons Corner Center

Wednesday March 20, 2019

7:00PM - 9:00PM

The Washington DC Access User's Group Quarterly Meeting will be held at the Microsoft Store in Tysons Corner Center. We will be sharing information among attendees and answering any questions. If you have a specific question, please bring your Access database with you, so that we can load it and view it.

For more information on the meeting, visit Washington, DC Microsoft Access Meetup.

Microsoft SQL Server Microsoft Azure and SQL ServerJanuary 30, 2019

FMS President Luke Chung's new paper discusses how to create Microsoft SQL Server Database Users and Permissions instead of Server Logins!

This information applies to Microsoft SQL Server hosted on your own platform and Microsoft Azure. Assumes you are familiar with SQL Server Management Studio (SSMS).

Visit our page Microsoft SQL Server Database Users and Permissions for more information.

Have any suggestions or comments? Head to our blog post Use Microsoft SQL Server Database Users Rather than Server Logins and leave us your feedback!

Office 365 and Access 2019

January 2019

Microsoft offers runtime versions of Microsoft Access so you can create database applications in MS Access and distribute them to non-Access owners. The runtime version allows your users to use your databases without purchasing their own license of Access/Office.

The Office 365 Access Runtime files are available as a free download in either the 32-bit (x86) or 64-bit (x64) versions in all supported languages.

You can download it from here: Microsoft Access Runtime Distribution and Free Downloads.

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 wer converted from MDBs with workgroup security.
  • Improved user interface to show progress of the documentation.
  • Revised user manual and help file.
  • and more...

For more information, visit:

Download the Free Trial to experience it for yourself.

Decades of Quality ResultsOctober 26, 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


For past FMS news, check out our News Archive and Legacy Press Releases.

FMS Resources

 

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

Alison Balter, Author, Trainer, Consultant

 

Questions

 

 

Free Product Catalog from FMS