FMS Email Newsletter

March 2021

For Microsoft Access, SQL Server,
Visual Studio .NET, and VB6 Professionals


Greetings!

FMS President Luke ChungIt's been a whole year since the World Health Organization declared a global pandemic. I think it's safe to say, we've never experienced such a year in our lifetime. We hope you are staying safe, and that you and your loved ones are not tragically affected by the disease. Economically, lots of people and businesses have suffered greatly, and our hearts go out to so many whose lives are turned upside down through no fault of their own.

In the software field, we are more fortunate than most to be able to work remotely, and through the use of Zoom, Teams, Remote Desktop and other technology, transform the way we work. In some cases, more productively. A few months ago, we released a new version of our Sentinel Visualizer program that reveals connections between people, places and events. Traditionally used in law enforcement, it has found application in contact tracing for COVID-19. Check out the example we illustrate below.

We are also nearing the final phases of updates for several of our products to support the latest versions of Access, Office 365, and Windows, so stay tuned for that! Meanwhile, we're maintaining a constantly evolving set of changes to Microsoft Access/Office with our Microsoft Office 365 Update Channel page.

Our newsletter includes papers with tips for using Microsoft Outlook and Office 365 and a subset of recent news. For additional information, visit our News Announcements page and receive our latest notifications from our Like Us on Facebook Facebook page, FMS BlogBlog, and FMS TwitterTweets.

We hope everyone receives their vaccines soon and for a speedy recovery to safe in-person meetings and travels.

All the best,

Luke Chung
President

Contents


Microsoft SQL Server Express Configure Microsoft SQL Server Express for Multiuser Environments

Microsoft SQL Server is an enterprise quality database management system that's usually hosted by a server and can scale across multiple servers and locations.

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. It can also host databases that are shared across your network.

We have a new page on how to do it: Configure Microsoft SQL Server Express for Multiuser Environments.

Total Access Emailer Using Total Access Emailer with SendGrid SMTP Server

Total Access Emailer lets you send personalized emails and attach filtered Access reports to all your contacts. It relies on an SMTP server to do so. Office 365 is a popular choice, but so is SendGrid which is offered with Microsoft Azure.

We have a new support page on how to integrate Total Access Emailer with SendGrid's SMTP protocol addressing some common issues that arise.

Visit our SendGrid SMTP Error 20162 support page for more information.


Microsoft Azure Remote App & Remote Desktop Running Microsoft Access via Remote Desktop and Remote App including Hosting on the Microsoft Azure Cloud

Since Microsoft introduced Terminal Services with Windows Server 2008, it is possible to host multiuser Microsoft Access applications (and other programs) without installing anything on the user's machines. Your users can run the programs from within your corporate network, or even across the Internet when hosted on the Microsoft Azure cloud. As a result, PC and Mac users can run your Access solution.

We can help you evaluate the options and tradeoffs, and implement a migration path to ensure a smooth transition to a remote hosted platform. For more information visit our page, Running Microsoft Access via Remote Desktop and Remote App including Hosting on the Microsoft Azure Cloud.


Microsoft 365How to Change the Update Channels for Microsoft 365 Apps

Having Microsoft 365 allows users to receive new and updated features to keep their Office apps like Access, Excel and Word current.

There are several Update Channel options that send new features, security updates and non-security updates at different periods of time. Our FMS Development Team has created a page that explains the different types of Update Channels for Microsoft 365 and how to change from one Update Channel to another.

For more information, visit How to Change the Update Channels for Microsoft 365 Apps.

Microsoft Access 2019 Microsoft Access Database Architecture: Storing Temporary Data and User Settings

Many users grow annoyed that they have to re-enter their last specifications when the application should start with those specifications as its default.

FMS President Luke Chung has written a page how to store Temporary Data and User Settings in your Applications.

For more information, visit Microsoft Access Database Architecture: Storing Temporary Data and User Settings.


Microsoft Access 2019Improved Date/Time Extended Data Type

Microsoft has introduced a new and improved Date/Time Extended Data Type. This allows users to enhance syntax compatibility with SQL, and to increase accuracy and level of detail in records that include dates and times. To enable this feature, select 'New Field' and then 'Date & Time Extended'.

For more information on this improved feature, visit Using the Date/Time Extended Data Type.

Microsoft 365 Microsoft Office 365 Access Update Version Releases

Microsoft Office 365 offers continuous updates that occur automatically monthly or every six months depending on your settings. Our team has created this page to list all of the updates that Microsoft released for the Microsoft Office 365 Update Channels.

For more information, visit Microsoft Office 365 Access Update Version Releases.


Microsoft Access 2019 SharePointRemove 'Save to SharePoint Site' Prompt from a Microsoft Access Database

Our FMS Developers received a client's Microsoft Access database that had the following prompt above the database when it was opened.

Save to SharePoint Site Prompt

They did not know how to remove this prompt because the original SharePoint site no longer exists, so clicking on the 'Save to SharePoint Site' button did not help. Fortunately, our developers found a simple solution, thanks to George Hepworth, Microsoft Access MVP!

For more information on the solution, visit Remove 'Save to SharePoint Site' Prompt from an Access Database.


Sentinel VisualizerCOVID-19 Contact Tracing Software

Contact Tracing is critical to minimizing the spread of COVID-19 in your community. Sentinel Visualizer can be used to store the data on your students, teachers, staff, family members, classes, clubs, sports, etc. When positive tests occur, quickly identify the common links.

Leverage your information to quickly identify those who need to be tested and quarantined while limiting the impact on the wider community. For more information and to see how Sentinel Visualizer can be used for contact tracing, visit COVID-19 Contact Tracing Software.

COVID-19 Contact Tracing Software

Sentinel VisualizerSentinel Visualizer Version 9 Released

Sentinel Visualizer is our advanced link analysis and data visualization program providing insight into patterns and trends hidden in your data.

We're pleased to release version 9 with many new features including shapes, layouts, document text search, get links between entities, transformations, dataset builder, improved performance and more!

For more information on the new features, visit our Sentinel Visualizer 9 page.

Sentinel Visualizer Version 9


Upcoming Virtual Microsoft Access Conference in 2021

Access DevCon in Vienna, AustriaVirtual Access DevCon 2021

April 22 - 23, 2021

Microsoft Access MVP Karl Donaubauer announced the Virtual Access DevCon will take place on April 22 - 24, 2021.

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

For more information, visit the Access DevCon website.


Upcoming Microsoft Access Conference in 2021

J Street TechnologyAccess Cascade Conference 2021

October 16 - 18, 2021

Portland, Oregon

Jack Stockton and PAUG (Portland Access User Group) have announced that they will be stepping down as organizers for the PAUG conference!

We at FMS want to thank Jack Stockton for all his hard work and dedication in bringing everyone together for a one of a kind Access Conference.

J Street Technology will assume the organizer role and has given the conference a new name - the Access Cascade Conference! It will take place on October 16 - 18, 2021 at the Conference Center in Silver Falls State Park, Oregon. For more information, visit J Street Technology Access Events.


Visit our Upcoming Events page for other activities.


Your Opinion Matters

Our newsletters are designed for you. To help us provide better service, please send us your suggestions and comments about "The Buzz", as well as our products and services.

See something useful you'd like to see more of it? Want more Microsoft updates?

Please Contact Us with suggestions, comments, or requests.

Past Issues of the BUZZ

Have you missed a past issue of our Buzz email newsletter?

You'll find recent issues conveniently archived for easy retrieval. Get all the tips, news, product updates, and more! (Past Issues)

Sign Up

Microsoft Partner


Thank you for your continued support!!

Watch our FMS BlogBlog, FMS Facebook PageFacebook page, and FMS TwitterTwitter feed for our latest announcements

Recent Newsletters

General

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

Connect with Us

More Resources

 

Free Product Catalog from FMS