Blog

Articles on MS Access design, relational database theory, and practical development techniques.

AI is a Process, Not Person

October 12, 2026

A few days ago I read a forum post by someone furious with an AI assistant. It had "forgotten" something they had told it. Part of me sympathized. AI can be frustrating that way. Another part of me, though, took the side of the AI. Let me explain why.

The Instruction That Read Like a Weather Report

October 8, 2026

OTS Templates only work if the AI assistant has the right knowledge in front of it at the moment it does each piece of work. This post is about two ways that goes wrong. One was a plumbing problem which we fixed. The other was a writing problem; that one was mine. I'm still learning how best to leverage the power of AI.

Calling Volunteer Testers: Open Template Scaffolds Gets Its Public Debut

September 20, 2026

The library gets its first public showing at two upcoming AUG chapter meetings:

  • Pacific AUG — October 1, 2026
  • Europe AUG — October 7, 2026
One Scan Behind

September 18, 2026

A stubborn error in one of my templates led to understanding about Domain Aggregate expressions inside transactions in VBA. I'm sharing that with you in case it is something you might find useful some day.

The other half of the story: an AI assistant finds its own bugs

September 14, 2026

In the previous blog, I talked about the four builds that followed different paths to reach the same destination. It was largely a success story.

I would be untruthful, though, if I didn't also share the negative side of the ledger: the deviations and false starts exposed in the build report and runbook. They happen. We learn from them and move forward. But there's also a good story to tell about that.

Four Builds, Four Different Roads, One Destination

September 12, 2026

A few days ago I ran the same audit-logging template four times against Northwind-derived test databases. As I expected, no two runs built the code the same way. That is not a bug in the template. It's AI, so I expect that.

The thing is that I had put a lot of work into crafting specifications and validation checks to make it work correctly despite those variations. I was very pleased, therefore, because even though the build paths were diverse, one thing didn't change. All four versions logged records in the audit table the same way.

Outcome-based instructions; what happens after the briefing

September 5, 2026

Today's blog is a response to Mike Wolfe's "Outcome-Based Instructions."

His argument in one line: with today's more capable AI models, tell them what you want to end up with, not how to get there.

A Self-Graded Build

September 4, 2026

Several people have asked me, "What does a template-driven build actually give me that telling an AI assistant to do something, like add audit logging to this database, does not?"

And frankly, the answer to that question, once I really thought about, was not what I had expected it to be.

The real advantage, I believe, is asking the right questions.

The Security Scan That Caused a Leak

August 25, 2026

I thought I had been careful enough. The AI Agent proved me wrong. We almost broke up over it. We've reconciled, but the trust problem lingers.

By the way, I'm not telling this story to get your sympathy. I'm sharing it so you can possibly avoid the mistakes I made.

Wanna say something? Go right ahead and say it. I'm listening.

August 24, 2026

Let's make this a dialog, not just a billboard.

After getting a request from a reader to allow feedback, I had Claude Code add the ability to do that. Let me know what you think, good or bad. Especially if it's good, though.

An error has occurred. This application may no longer respond until reloaded. Reload ✖