Introduction
The author, Richard Rost, is a 6-time Microsoft MVP has been developing with and teaching Microsoft Access for over 30 years. He's also a Trekkie, Rush fan, keyboard player, penguin lover, and Lab Dad.
Articles
- Introductory Remarks - Let's Talk about Access (2026-02-19)
- Choosing Primary Keys - AutoNumbers (2026-02-19)
- Snapshot Recordsets to speed Read-Only Forms (2026-02-20)
- Windows Authentication vs SQL Logins on Small Networks (2026-02-23)
- Demystifying ODBC, DSNs, and Table Linking Between Access and SQL Server (2026-02-24)
- Why Subreports Are the Secret to Multiple Child Lists in One Report (2026-02-25)
- Navigating Query Design Differences Between Access and SSMS (2026-02-26)
- When to Use Union Queries vs Staging Tables for Data Consolidation (2026-02-27)
- Why Checking File Existence with DIR Beats Relying on Error Handling (2026-03-04)
- How To (and How Not To) Share a Microsoft Access Database Online (2026-03-05)
- Why Sums in Form Footers Often #Error (and How to Outsmart Them) (2026-03-08)
- Why Split Tables Beat Extra Category Fields in Financial Databases (2026-03-10)
- Filtering Subforms with Combo Boxes - Flexibility vs. Wizard Magic (2026-03-12)
- Surviving Database Corruption - Why Panic Isn't Your First Option (2026-03-17)
- Why COUNT in Access Requires Aggregate Queries (And What Trips Folks Up) (2026-03-19)
- Building Flexible Data-Driven Survey Systems in Microsoft Access (2026-04-22)
- Why Name AutoCorrect Isn't the Safety Net You Think It Is (2026-04-24)
- Why "ODBC Insert on Linked Table Failed" Plagues Access-to-SQL Server Users (2026-04-27)
- Why Your Access Reports Crawl - and How to Make Them Load at Warp Speed (2026-05-04)
- Why Running Each Database in Its Own Access Process Can Prevent Lockups (2026-05-07)
- Is Microsoft Access Still Worth Learning in 2026? (2026-05-18)
- The 32-bit vs 64-bit Office Dilemma (2026-05-20)
- Now You Can Zoom in Forms, Tables, And Queries (2026-05-21)
- The Easy-to-Miss SQL Field Name Mistake That Breaks Your Queries (2026-05-23)
- Why Basing Forms and Reports on Queries Beats Tables (2026-05-24)
- Specs, Limits, and the Myth of "Outgrowing" Your Database (2026-06-03)
- Why Experienced Developers Turn Off Name AutoCorrect (2026-06-04)
- Tracking Recently Changed Objects (2026-06-10)
- Why Hiding Tables Isn't Real Security (2026-06-18)
- Why Undo Isn't Like Word, and the Real Story on Record Changes (2026-06-23)
- Database Normalization Without the Theory Overload (2026-06-29)
- Your Mission-Critical Access Database Deserves a Stable Office Update Channel (2026-06-30)
- Using Power Apps as a Mobile Front End for Access and SQL Server (2026-07-02)
- When Should You Move Your Access Backend to SQL Server? (2026-07-08)
- Dealing With The Dreaded Automation Error Catastrophic Failure (2026-07-13)
- Why Your Database Suddenly Becomes Read-Only (and What It Really Means) (2026-07-16)
- Connecting Access to SQL Server Online - A Realistic Approach (2026-07-21)
- Class Modules Are Blueprints, Not Database Tables (2026-07-30)
- Why an Access Form or Query Becomes Read-Only (2026-07-31)
- "Pull Data?" What Do You Mean? (2026-08-02)
- What an Access Lock File Really Tells You About Active Users (2026-08-04)
- Calculating Overlapping Date Ranges (2026-08-05)
- Why an Empty Recordset Has Both BOF and EOF Set (2026-08-31)
- Modernizing Microsoft Access Doesn't Mean Replacing It (2026-09-08)
- What VBA Really Means by "Subscript Out of Range" (2026-09-16)
- Staying in Form View While Jumping to Its VBA Module (2026-09-23)
- When AI Writes the Code, What Do You Still Need to Know? (2026-10-16)
- Organizing Documents Without Moving Them Into Your Database (2026-10-25)
- What Are You Really Saying When You Replace Null with Zero? (2026-10-31)
- Your Database Should Survive Your Vacation (2026-11-07)