Microsoft Access automation

Automate your Microsoft Access app.
Without rewriting it.

Your business runs on an Access database someone built years ago. Fleet AI works its forms the way your staff does: it reads grids, ticks rows and presses buttons, then checks every change against what Access itself reports.

Works with Access forms, subforms and datasheets in .mdb and .accdb apps. Nothing to install inside the database.

Example run
  1. 01Read the bank statement87 transactions from PDFFile
  2. 02Read open items from the Reconcile form85 rows, read directlyAccess
  3. 03Match on amount, check number and date84 matched · 1 flaggedMatcher
  4. 04Tick 84 rows, verifying each one~17 secondsAccess
  5. 051 item needs you: no match foundApproval
  6. 06Done. Report saved to the runDone

Example run — Monthly bank reconciliation

Sound familiar?

The app works. The busywork around it doesn't.

No API, and the developer is long gone

The app works and the business depends on it, but nobody wants to touch the VBA. Integrations are off the table.

Rewriting it is a six-figure project

Migrating years of forms, reports and business rules to a new system is slow, risky and expensive, so it never quite happens.

So people do it by hand

Ticking hundreds of rows during a reconciliation. Retyping data from PDFs. Running the same report every Monday. Hours a week, every week.

What it automates

The Microsoft Access work Fleet AI takes off your plate.

Start with one task. Once it runs reliably, add the next. Every workflow is yours to read, edit and schedule.

Bank & account reconciliation

Read the bank statement, read the open items from your Access form, match them on amount, reference and date, then tick the matched rows. Anything uncertain is flagged for you.

Data entry from documents

Key data from PDFs, emails and spreadsheets into your Access forms through the forms themselves, so your validation rules and event code still run.

Look-ups & quick answers

"How many payments are still uncleared?" "What's the deposit subtotal?" Fleet reads the open form directly, including the totals Access calculates. No screenshots, no export.

Reports & exports

Run the database's own reports, export them to Excel or PDF and send them where they need to go, on a schedule.

Moving data between systems

Copy records out of Access into Excel, a web portal or your accounting software, and back again, without the copy-paste marathon.

Month-end routines

The same 40-step sequence every month, done the same way every time and recorded so you can check it.

Why it works

It reads Access directly. It changes things the way your staff does.

Screen-only AI agents squint at a datasheet and click checkboxes one screenshot at a time. Fleet AI reads your forms directly from Access, and makes changes through the forms themselves, so your app behaves exactly as it does for your staff.

01

Reads forms, not screenshots

Grids, controls and computed totals are read straight from the open Access form, including what's on screen but not saved yet. Fast, exact and cheap.

02

Changes go through your forms

Fleet never writes to your tables directly. Every change is made through the form, so your app's own rules and event code run, then it verifies each row afterwards.

03

Stops when something's off

If Access raises a dialog or an error, Fleet reads the message and pauses for you instead of clicking through it. Finish, Post and Delete are off-limits unless your workflow says otherwise.

Proof

A real reconciliation, before and after.

A bank reconciliation in a Microsoft Access line-of-business app, about 85 open items per month. We first ran it with a screen-only AI agent, then with Fleet AI reading the form directly.

~17 s
to tick and verify 84 rows
~7 min
for the whole reconciliation, start to finish, statement reading included
7 rows
all a screen-only AI agent managed before it got stuck in a loop

Measured on Fleet AI's production platform, September–October 2026.

How it works

From install to first run.

  1. Step 1

    Connect the computer

    Install the Fleet agent on the Windows PC or cloud desktop that already runs Microsoft Access. It connects out to Fleet AI — no inbound ports, no VPN.

  2. Step 2

    Describe it, or show it once

    Describe the task in plain English, or do it once while explaining it. Fleet turns it into a workflow with steps you can read, edit and schedule.

  3. Step 3

    Approve and run

    Approve the plan, then run it with one click or put it on a schedule. Choose the steps where it must wait for a human.

  4. Step 4

    Check its work

    Every run is recorded step by step. Watch it live, take over at any moment, or review it afterwards like an employee's work.

From your AI assistant

Use Claude or ChatGPT with Microsoft Access

An Access app has no API for an AI assistant to call. Add Fleet AI as a connector in Claude or ChatGPT, and you can ask for work in your Access app from a chat. The assistant hands the job to Fleet, Fleet works the forms on your computer, and the assistant reads you the result.

Things you can ask
  • “Reconcile October's bank statement against the Reconcile form in our Access app, and list what you couldn't match.”
  • “How many payments are still uncleared in the Access app?”
  • “Run the month-end report in our Access database and save it as a PDF.”

You sign in to Fleet and pick the computers the assistant may use. Plans and questions wait for a person by default.

FAQ

Microsoft Access automation, answered.

Do we need to change our Access database?

No. Nothing is installed inside Access, no tables or modules are added, and your VBA is untouched. Fleet AI works with the app as your staff sees it.

Which Access apps does it work with?

Line-of-business apps built in Microsoft Access (.mdb or .accdb) running on Windows: forms, subforms, datasheets and reports. If your team can do it in the app, there's a good chance Fleet AI can too. Bring an example to the call.

Could it corrupt our data?

Fleet AI never writes to your tables directly. Changes go through your forms, one verified step at a time, and it stops and asks you whenever Access shows a dialog or something doesn't add up.

What if the app shows an error or a popup?

Fleet checks for Access dialogs before every action. If one appears, it reads the message and pauses the run for you, with the dialog's text, instead of guessing which button to press.

We also have FoxPro / an old VB app / a custom ERP. Does that work too?

Yes, though not as fast. Sage 50, Microsoft Access and Excel have built-in Fleet actions. Other Windows apps are worked through control names and the screen, which takes more steps. For an app you run every day, ask us about built-in actions.

Where does it run?

On the Windows PC or cloud desktop where your Access app already runs. You install the Fleet agent, which connects out to Fleet AI. No inbound ports and no VPN.

Show us the Access screen your team lives in.

Tell us the task and we’ll show you Fleet on it. Or create an account and start with $10 of credits.

Book your discovery call

Tell us the task your team hates most. We’ll reply by email to set up a time.

Or email support@tryfleet.ai