Open the app

Microsoft Access to web app

An Access database, now a web app

Northwind's orders, stock and invoices: out of one file on one PC, into any browser. Same records, same rules.

Open the app Move my Access database

  • 830 orders
  • 91 customers
  • 77 products
  • 122 still open
  • $186,926.64 waiting to be paid

Before and after

Before: Access

  • One .accdb file on a shared drive
  • Windows PCs in the office only
  • Shared over the network, the file can get corrupted
  • Rules hidden in form code (VBA)
  • Reports print from Access
The Home ribbon of Microsoft's Northwind 2.0 template in Microsoft Access: Orders, Add Order, Purchase Orders, Companies, Products, Employees and ReportsNorthwind 2.0's Reports form in Microsoft Access: a list of sales and employee reports, and a start and end date
Northwind 2.0 in Microsoft Access, from Microsoft's help pages. Used with permission from Microsoft.

After: web app

  • One database on a server (PostgreSQL), backed up
  • Any browser: office, home, Mac, phone
  • Everyone works at once
  • Rules on the server, with tests
  • Invoices and reports print or save as PDF
The same reports in the web app: sales by employee for 2026 with a bar per person, next to the app's menu
The same reports, on the web. Open them

Try it

  1. 1

    Invoice an order. Order 11071 has its stock. Invoice it

  2. 2

    Fix a stock problem. Order 11045 is short of dried apples. Order more, approve as Andrew Fuller, receive, invoice. Open order 11045

  3. 3

    Ship, get paid, close. A shipped order can't close until its payment is in. Shipped orders

  4. 4

    Print. Sales by employee, by product, money owed, and any invoice as a PDF. Reports

What moved where

In AccessOn the web
Tables in the .accdb filePostgreSQL tables on the server
Forms and subformsReact screens that work on a phone
VBA behind the buttonsC# rules every change goes through
QueriesLists, filters and search
ReportsPrint pages and PDFs
Login formSign-in, with what each person may do

Where it comes from

The data is Microsoft's Northwind sample database, under the MIT License (source), with the dates moved to today. The order steps follow Microsoft's Northwind 2.0 Access template, as its help pages describe them. The screens and code are AI Web Center's. Northwind Traders is fictional.

Open the app How we built it Have your Access database moved