Microsoft Access, SQL Server, and Visual Studio .NET Products and Services

Celebrating our 40th Year!

Providing products and services to customers in over 100 countries

Send Personalized Emails from Access

Easily generate personalized emails from Microsoft Access with attached PDF reports for each recipient

Disaster Recovery and System Administration

Automate Microsoft Access Database Compacts and Other Chores Across Your Network

Database Documentation and Analysis

Detect 300 types of errors, design suggestions, and performance tips to improve your Microsoft Access databases

Compare Any Two Databases or Objects

Know exactly what changed with Microsoft Access tables, fields, data, controls, properties, macros and modules

Royalty Free Source Code Library

227 modules, 3600+ procs, 125,000+ lines of VBA and VB6 code professionally designed, written, tested, and documented

Advanced Data Analysis in Microsoft Access

Extend the power of Microsoft Access queries to calculate Percentiles, Rankings, t-Tests, Regressions, ANOVA, etc.

Who's in Your Microsoft Access Database?

Monitor and Log Users Entering and Exiting Your Microsoft Access Databases in Real-Time

Create and Enhance Your VBA and VB6 Code

Code builders, cleanup existing code, add error handling, line numbering, obfuscation, unused variable analysis, etc.

Save with our Multi-Product Suites

Maximize Your Investment in Microsoft Access with our 12 Productivity Tools

Microsoft Access Resource Center

Total Access Detective 2026 Shipping NEW!

Total Access Memo 2025 Shipping NEW!

Total Access Emailer 2022 Shipping

Total Visual Agent 2021 Shipping

Microsoft Access Products

Microsoft Access Consulting and Programming Services

Microsoft Access Help

Microsoft Access Developer Center

Microsoft Access Versions Feature Matrix

Microsoft Access Version Releases, Services Packs, Hotfixes, and Updates History

FMS News

FMS News Updated!

Avoid Mapped Network Drives running Total Visual Agent as a Windows Service

Google Gmail OAUTH 2.0 and Total Access Emailer

Microsoft Office365 Changed SMTP Transport Layer Security (TLS)

Link Analysis Software

How to Change the Update Channels for Microsoft 365 Apps

Access DevCon RemoteApp Video

Last Newsletter

National News Media Videos

Microsoft Access Query Center

Microsoft Access Query Help Center Main Access Query Help Center

Access Query Tips and Techniques

Append Queries REVISED!

Delete Queries REVISED!

Update Queries; Converting a Field to Proper Case

Not-In Outer Join Queries

Crosstab Query in Reports

Union Queries

Database Strategy

Taking Over Legacy Microsoft Access Databases

Microsoft Access Version Features and Differences Microsoft Access Version Differences

Strategically Using Microsoft Access within Your Organization

Microsoft Access vs. Excel

Inheriting Microsoft Access Database Applications

Learn from FMS's experiences:

Technical Videos

Microsoft Outlook Tips

More Tips and Techniques

Microsoft Access to SQL Server Upsizing

Microsoft Access to SQL Server Upsizing Center

When and How to Upsize MS Access to SQL Server

Linking Microsoft Access to SQL Azure Databases

Deploying MS Access DBs linked to SQL Azure Updated!

Microsoft SQL Server Express Editions

Microsoft Azure, RemoteApp and Cloud

Microsoft Azure Security Holes with SQL Server Databases

Move Azure SQL Server Databases to Elastic Pools

Monitor SQL Server Usage and Setting DTU Limits on Azure

What Azure Means to Information Workers

RemoteApp and Terminal Services

Remote Desktop Connection Tips

Remote Desktop Connection Authentication Error

Products for Microsoft Access Users, Developers and Administrators

Total Access Analyzer

Total Access Components

Total Access Detective

Total Access Emailer

Total Access Memo

Total Access Speller

Total Access Startup

Total Access Statistics

Products for Microsoft Access, Office and Visual Basic 6 (VB6) Developers

Total Access Admin

Total Visual Agent

Total Visual CodeTools

Total Visual SourceBook

Big Data Analytics and Visualization

Sentinel Visualizer

USPS Zip Code Database Subscription

Total Zip Code Database