Working with Microsoft Access?

An Access database nobody owns? We take it on.

Most Access apps that reach us were built years ago by someone who has since left, and the business still runs on them every day. We learn how the thing actually works, keep it running, and move it somewhere safer when the time comes.

  • Since 2015Fixing technology
  • FreeEstimates
  • US teamReal engineers

access.log

still failing

What it is

Microsoft Access at a glance

Microsoft Access is a desktop relational database from Microsoft, first released in 1992, and shipped as part of Microsoft 365 and older Office bundles. The .mdb and newer .accdb files hold the tables, queries, forms, reports and VBA code in a single file.

It is often the back end of a departmental app that outgrew a spreadsheet but never made it to a real database or a web application. Plenty of businesses still depend on one of these, and nobody can remember who originally built it.

Type
Desktop relational database and app builder
First released
1992
License
Proprietary, part of Microsoft 365 Business or Family
Maintained by
Microsoft Corporation
Typically used for
Departmental tools, inventory and asset trackers, custom forms over Excel data, small CRMs

The honest version

Microsoft Access pros and cons

No technology is all upside. This is where Microsoft Access earns its place and where it tends to cause trouble.

Where Microsoft Access is strong

  • A working app in a dayA non-developer can build a usable database with forms and reports in an afternoon, which is why so many of these exist in the first place.
  • It plugs into OfficeTight links with Excel, Outlook, Word and SQL Server mean data moves between tools your staff already know, without a glue layer in the middle.
  • Decades of working examplesBecause so many businesses have run on it for so long, almost any pattern you need has been built before and is easy to copy.
  • Already paid forIt comes with the Microsoft 365 Business plans most offices already buy, so there is no separate licence to approve.
  • More capable than it looksFor a team of a few people with modest data, a well-built Access app is surprisingly quick to use and quick to change.

Where Microsoft Access bites

  • Not really multi-userSeveral people editing the same file over a network share leads to corruption. It was never designed for concurrent writes across a LAN.
  • The 2 GB ceilingAn .accdb file is capped at 2 GB. Busy databases creep toward this limit and start behaving oddly long before they hit it.
  • No modern web front endAccess web apps were retired in 2018 and never replaced. There is no supported way to put an Access database on the web as Microsoft intended.
  • Tied to Windows and M365The runtime and the file format bind you to the Microsoft stack. Staff on Macs, phones or Linux cannot open these files at all.
  • Awkward to versionAn .accdb is a binary blob. Git sees only one file changing, so code review and change tracking are harder than with normal source code.
  • VBA keeps shiftingEach Office version can re-license or quietly break the VBA references an app depends on, and the fix is rarely written down anywhere.

Sound familiar?

Common Microsoft Access problems we fix

The Microsoft Access problems that bring people to us, and what you have once each one is fixed.

built by someone who left in 2014

The original developer is long gone

An important app still runs the business but nobody on staff knows how it is put together or dares to open the code.

Documented, and someone owns it

Can't repair this database

The .accdb file is corrupt

Usually a bad network write or a crashed client while someone had the file open. The built-in repair gives up and leaves you locked out.

Recovered to a working copy

fast for one user, crawls for six

It slows to a halt with a few users

A single-file database being pounded over an SMB share. Each user drags more data across the wire than they need.

Back end moved off the share

accdb size: 1.94 GB

The file is close to the 2 GB limit

Years of records, images stored inside the database, and bloat from edits that compact-and-repair cannot fully reclaim.

Trimmed, and a plan past 2 GB

VBA references broken after M365 update

An Office update broke the app

A new Office build changes a reference or VBA setting, forms stop loading, and no one on site can read the error.

References pinned, update tested

no web version exists

Staff need it from outside the office

The business has moved on from one shared office, but the app only works from a Windows PC on the LAN.

Front end on the web, data safe

last backup: who knows

There is no reliable backup

A copy of the file somewhere on a user's desktop, or a backup job nobody has tested restoring from.

Backed up nightly, restore tried

ODBC call failed

The link to SQL Server keeps dropping

Linked tables through an old ODBC driver, timeouts on slow queries, or a server move that nothing was told about.

Connection stable and monitored

What we do

Microsoft Access help, from rescue to replacement

Call us for one broken form, or hand us the whole app.

Rescue
Corrupt files, locked databases, or an app that stopped working after an Office update. We get it open first, then find the cause.
Takeover
An app with no maintainer left. We read the code, write down how it actually works, and become the people you call.
Performance
Fixing the forms, queries and linked tables that bog down with more than a few users, measured before and after.
Migrations
Moving the data to SQL Server or a managed cloud database, and the app itself to a modern web or desktop front end.
Custom work
New forms, reports and integrations built against the existing database without breaking what already works.
Managed Tech
Backups, updates, monitoring and a team to call, so the next time someone leaves the app does not leave with them.

How it works

From first message to fixed

  1. Look Free estimate

    Tell us what's going wrong. We look at it, then tell you plainly what's wrong and what it will cost.

  2. Fix

    We fix the cause, not the symptom. If something is down, getting it back up comes first.

  3. Harden

    Backups, monitoring, updates and access, so the same problem can't quietly come back.

  4. Hand back or stay on

    You get a plain-language write-up. Or we stay on for hosting, upkeep and new work.

Often found together

Running Microsoft Access alongside something else?

We work on the whole stack, so the problem can be wherever it actually is.

Questions

Microsoft Access questions

Something else? Call+1 737 727 7327

Is Microsoft Access safe to keep using?

For a small group of people and a file well under 2 GB, yes, if it is backed up and someone owns it. It becomes risky when the only person who understood it has left and no one has looked at it since.

Can you migrate our Access database to SQL Server or the web?

Yes. The usual route is to move the tables to SQL Server first, keep the Access forms running against the new back end, and then replace the front end with a web app at a pace that suits the business.

Our Access database is corrupt, can you fix it?

Often, yes. We work on a copy, try the tools Microsoft ships first, then fall back to lower-level recovery if those fail. The important step is to stop using the broken file before anything else overwrites it.

What replaces Access web apps now?

Microsoft retired Access web apps in 2018 without a direct successor. The practical options today are a Power Apps front end over a Dataverse or SQL back end, or a regular web application. We help pick the one that fits what the app actually does.

Why does our Access app slow down when more than three people use it?

Access was not designed as a true multi-user database. A shared file over the network has every client reading large chunks of it at once. Moving the tables to SQL Server and keeping Access as the front end usually fixes this without rewriting the app.

How much does Microsoft Access help cost?

Estimates are free. Send over the file or screenshots of the forms and errors, and we come back with a scope and a number before anything is touched.

Free estimate

An Access database on your hands?

Tell us what you're running and what's going wrong. A person reads it and comes back with an estimate.

  • No charge to find out what it will take
  • If it's urgent, say so

Replies come from a person. By sending, you authorize us to email you back. No marketing.