Jan 28

Total Access Emailer and Office 365 SMTP with TLS

Total Access Emailer is the most popular email automation system for Microsoft Access. Total Access Emailer uses your SMTP server to send emails. A popular choice is the SMTP server provided by Microsoft Office 365’s Exchange Server.

Total Access Emailer and the Office 365 SMTP Server

Total Access EmailerAssuming the account is properly configured to relay email messages (Mailbox Delegation), Total Access Emailer has supported Office 365 since it was introduced.

Over the years, Microsoft has increased security on their site and adjusted configurations for their SMTP server. You can connect via SMTP protocol using an approved IP address or Transport Layer Security (TLS) protocol for a specific email address.

Instructions for configuring Office 365’s SMTP server are provided here:
Office 365 SMTP Relay Configuration to Send Emails via the Office365 Exchange Server

Problem with TLS Connections

In the last week, we confirmed that Office 365 and Windows made changes that cause Total Access Emailer to be unable to send emails with its TLS connection protocol with an error like this:

SMTP protocol error: TLS 1.0 and 1.1 are not supported

The message implies the need for TLS 1.2, but recent versions of Total Access Emailer already support TLS 1.2.

What is not supported is TLS 1.3 that recent changes with the Office 365’s SMTP server and Windows seem to require. Here’s a Microsoft article about TLS 1.3: Taking Transport Layer Security (TLS) to the next level with TLS 1.3.

NOTE: TLS still works with many other SMTP servers including Gmail’s smtp.gmail.com (details for Using Total Access Emailer and Gmail).

Workaround: Use SMTP Protocol

If you are having trouble using TLS protocol, the SMTP protocol still works for Office 365. You need to authenticate your IP Address where you’re sending the emails. Remember to use the Temail.txt to store the FROM email address to use for validation as instructed in the referenced page above.

We realize that is not possible for all the environments of Total Access Emailer users.

New Versions of Total Access Emailer

This has accelerated our ongoing development for a new version of Total Access Emailer to address the new protocols. Our development team has already created a solution that is working with the new protocols and hope to release it, as soon as it completes thorough testing. We expect to release these Access 32 and 64-bit versions:

  • New Product:
    • Total Access Emailer 2021 for Access 2021, 2019 and the current Office 365 version
  • Updates:
    • Total Access Emailer 2016
    • Total Access Emailer 2013
    • Total Access Emailer 2010

New versions are now available! Visit the Total Access Emailer page for more information on the new features or ordering information.

Receiving the New Version

Customers on Premium Support Contracts will receive a free update for their version when it is available. Existing customers will be able to purchase an upgrade at a discounted price.

Jun 24

Total Access Memo 2021 is Now Available!

We are excited to announce the release of Total Access Memo 2021! Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking. Our super-easy data binding means you can display rich text on your forms and reports and store it in your tables.

memoGive your users the ability to add text with different fonts, point sizes, fonts styles (bolditalics, underline, etc.), bullet points, tabs, paragraph margins, indentations, alignment, spacing between paragraphs, color, graphics, hyperlinks, etc .

Total Access Memo 2021 is an upgrade from the 2007 version and includes these enhancements:

  • Support for 64-bit Versions of Access/Office including 365
  • Backwards Compatibility
  • Improved Rich Text Editor
  • Enhanced Sample Database
  • Updated Manual and Help File
  • New Setup and Distribution Programs

Download the free trial to experience it for yourself.

Existing Total Access Memo owners are eligible to upgrade at a discounted price.

May 15

Video: Remote access to Microsoft Access from DevCon Austria

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.

If you missed the event, you can visit Virtual Access DevCon 2020 to watch all the presentations giving by all of the speakers.

Luke Chung’s video presentation

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 Microsoft SQL Server.

PowerPoint Slides for the Presentation

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.

Aug 17

Total Access Emailer Version X.7 for Microsoft Access 2013, 2010, and 2007

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email

With the recent release of Total Access EmailerTotal Access Emailer for Microsoft Access 2016, we are pleased to release updates of earlier versions to include the many new features:

  • Total Access Emailer 2013, Version 15.7
  • Total Access Emailer 2010, Version 14.7
  • Total Access Emailer 2007, Version 12.7

Total Access Emailer is the most popular email blaster for Microsoft Access. Easily send personalized emails directly from your Access database. Quickly communicate with every email address in your table or query. Use fields from your data source to customize each subject and message. Attach files from disk and also attach reports as PDF files filtered for each recipient.

The new X.7 version includes many new features since their previous version:

  • email-validationEmail Validation to check the syntax of the values in your email field so you can flag invalid emails in your table before you send your blast
  • Save Attached Files to Disk. This lets you document the attached files sent to all your contacts without using blind cc (Bcc).
    • This can also be used independent of sending emails as a way to distribute files and PDF reports to disk. You can even create folder names based on field values.
  • Preview Saving Files to Disk
  • New VBA Function to Preview Email Blasts with Save Files
  • Code Generator Supports Preview Email with Save Folder
  • Support for Office365 and other SMTP Services using TLS
  • Enhanced setup for Windows 10 and 64-bit installations
  • Updated user manual and help file
  • Complete list and additional details of new features in Total Access Emailer X.7.

download-trial-blueDownload the free trial version and send your own personalized emails from Microsoft Access.

Create multiple email blasts in your database and run them at any time through the Total Access Emailer add-in Wizard:

Main Screen of Total Access Emailer 2016

Jun 13

Total Access Emailer Ships for Microsoft Access 2016

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email

Total Access EmailerTotal Access Emailer is the most popular email blaster for Microsoft Access. Easily send personalized emails directly from your Access database. Quickly communicate with every email address in your table or query. Use fields from your data source to customize each subject and message. Attach files from disk and also attach reports as PDF files filtered for each recipient.

Total Access Emailer is now available for Microsoft Access 2016. Total Access Emailer 2016 includes many enhancements since the prior release for Access 2013:

  • Supports Access 2016
    • 32 and 64-bit versions
    • Add-in and VBA Runtime libraries in the Professional Version
  • email-validationEmail Validation to check the syntax of the values in your email field so you can flag invalid emails in your table before you send your blast
  • Save Attached Files to Disk. This lets you document the attached files sent to all your contacts without using blind cc (Bcc).
    • This can also be used independent of sending emails as a way to distribute files and PDF reports to disk. You can even create folder names based on field values.
  • Preview Saving Files to Disk
  • New VBA Function to Preview Email Blasts with Save Files
  • Code Generator Supports Preview Email with Save Folder
  • Enhanced setup for Windows 10 and 64-bit installations
  • Updated user manual and help file
  • Complete list and additional details of new features.

download-trial-blueDownload the free trial version and send your own personalized emails from Microsoft Access.

Easily Run and Manage the Email Blasts You’ve Created in Your Database

Main Screen of Total Access Emailer 2016

May 05

Total Access Statistics for Microsoft Access 2016

Total Access StatisticsTotal 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.

Easily generate statistical values such as:

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-trial-blueDownload the Free Trial to experience it yourself.

Owners of Total Access Statistics for earlier versions of Microsoft Access can upgrade at a discounted price.

Apr 15

Total Access Startup Available for Microsoft Access 2016 and 2013

total-access-startupTotal Access Startup makes it easy to centrally manage all your Microsoft Access database deployments. Ensure that all your users run the latest version of your database application with the right version of MS Access. Easily deploy updates without having to manually change things on each user’s PC. Simply point your users to a shortcut and they never need to know the actual name of the database.

overview

Total Access Startup 2016 is now shipping to let you:

  • For optimal performance, deploy a local copy of your master database on each user’s PC and keep it updated when you update the master
  • Run it with a specific Access version or a range of allowable Access versions. This makes it easy to support legacy versions of Access even if users install later versions of Office/Access.
  • Specify the bitness (32 and/or 64-bit) that are allowed for Access 2010, 2013, and 2016.
  • Display a professional splash screen graphic while your database loads
  • If your users can’t launch your database, a message appears with information you provide to contact you. You can customize our messages or translate them to your user’s language.

startupMore Resources

Total Access Startup is also part of the Total Access Ultimate Suite. Existing Total Access Startup customers can upgrade at a discounted price.

Nov 05

Total Visual SourceBook 2013 Ships

Total Visual SourceBook Total Visual SourceBook

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.

code-explorer-web

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

Aug 01

Total Access Statistics Ships for Microsoft Access 2013

Total Access StatisticsTotal 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

Here’s a complete list of new features. For more information visit these resources:

Mar 22

Total Visual Agent Ships for Microsoft Access 2013 and 2010

Microsoft Access Database SchedulerTotal Visual Agent for Microsoft Access DatabasesAutomate Microsoft Access Database Compact and Other Chores

We are very pleased to announce that Total Visual Agent 2013 is now shipping.

Don’t Forget System Administration for Microsoft Access Database Solutions

A professional Microsoft Access database application needs ongoing system administration. It’s an area that many MS Access developers neglect and causes problems when things go wrong (database corruption, missing backups, disaster recovery, etc.):

Enterprise Quality System Administration with Audit Logs and Email Alerts

Total Visual Agent has provided an Enterprise Quality solution for almost 20 years by giving organizations a reliable way to perform their critical tasks on a 24/7, 365 days a year basis. A detailed audit log documents each action that is performed, and sends emails if errors are encountered.

Schedule Events, Databases, and Actions to Perform

Total Visual Agent automates and schedules Microsoft Access tasks. It ensures repetitive tasks are completed reliably. Tasks such as database compact and repair, zipped backups, rolling backups (e.g. 7 copies for each day of the week), running macros, running Windows command lines, making copies of table data, collecting database statistics such as size and record counts, etc. Easily schedule tasks for the middle of the night and know they’ll be completed.

Events can be scheduled every X minutes, hourly, daily, weekly, monthly or just one time. You can specify the days of week and time periods that it runs to limit processing to off-hours. Select the databases and directories (including subdirectories) to manage with support for workgroup security and database passwords.

Includes a Windows Service for Secure Processing and Reliability

Once defined, the events and tasks can be run by our Monitor program that is a standard Windows program.

Alternatively, Total Visual Agent includes a Windows Service, so you can run your tasks without having anyone logged on the machine. The Windows service is a more secure, robust solution since it can automatically restart if the machine reboots.

New Features in the 2013 Version

A huge number of new features were added in this 2013 release from the previous 2007 version:

  • Microsoft Access 2013Support for Microsoft Access 2013 and 2010, plus 2007
  • 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

For complete list, visit New Features in Total Visual Agent 2013.

Download a Free Trial Version

A fully functional trial version is available for download so you can run it on your system with your databases.

Contact Us

  • Visit our Support Site if you would like to submit any questions to our technical support team.
  • Place an order online. Existing customers can upgrade at a discounted price.