Skip to content
Get a free demo
Guide

How to replace Microsoft Access

List everything the database does today, tables and reports alike, then choose how much to replace. You may not need to replace all of it at once.

Should you replace it at all?

Access is still a capable tool for a small office on one network. If the database works, a few people use it from Windows computers in the same building, and somebody can maintain it, leaving it alone is a respectable decision.

These are the usual reasons to move:

  • Remote work. Access files don’t behave well over the internet or a slow VPN, and a dropped connection can corrupt a shared file.
  • Phones and Macs. Access is a Windows desktop program, so staff on phones, tablets or Macs can’t use it directly.
  • Size. Microsoft sets a limit of 2 GB, minus system objects, for a single database file.
  • The person who built it is leaving. A system only one person understands is a risk whatever it runs on.
  • Access web apps are no longer an option. Microsoft no longer recommends building them in SharePoint and points people to Power Apps.

Take inventory first

An Access database is usually much more than its tables, and the forgotten parts are what make a replacement fail.

What to list before you move anything
PartWhat to recordWhy it matters
TablesRow counts, relationships, linked tablesLinked tables may point to Excel files or servers nobody remembers.
QueriesWhich ones are still usedMany hold business rules, such as how a discount is worked out.
FormsWho uses each, and what they doThis is where your daily work happens, so it sets the shape of the new screens.
ReportsWhich ones people actually print or sendReports are often the hardest thing to reproduce exactly.
VBA and macrosWhat each one automatesThis logic doesn’t move by itself. It has to be rewritten.
PeopleWho uses it, from where, and whenIt decides how you can safely run the switch.

Ask users what they do outside the database, too. A spreadsheet kept next to it often reveals a feature the database never had.

Your options, side by side

Ways to replace or extend Access
OptionWhat changesGood whenWatch out for
Keep the Access screens, move the data to SQL ServerTables move; forms and reports stay in Access, linked to the serverSize or reliability is the only problemUsers still need Access on Windows
Microsoft Power AppsScreens are rebuilt in Microsoft’s low-code toolYou already use Microsoft 365 and your forms are fairly simplePer-user licensing, and complex reports need another tool
Another no-code builderData and screens are rebuilt on that platformA small internal tool with simple rulesLimits on logic, and your app lives on their platform
A custom web appEverything is rebuilt, around how you work nowStaff need it anywhere, and your rules are particularThe highest upfront cost; you depend on whoever builds it

Moving the tables to SQL Server

Microsoft provides a free tool for this, SQL Server Migration Assistant for Access (SSMA). It assesses the database, converts the table definitions, moves the data, and can link the Access tables to the new server so existing forms keep working. It targets SQL Server and Azure SQL.

Run its assessment report before anything else, because it lists what won’t convert. Then test on a copy, and expect some queries to need attention: a query that runs fine locally can be slow when it has to pull a table across the network.

Plan the switch

  1. Back up the database and store a copy where nobody will touch it.
  2. Compact and repair it, then clean the data. Our guide on organizing scattered data helps if there are side files to bring in.
  3. Export your important reports as they look today, because they become the test for the new system.
  4. Rebuild in small parts, starting with whatever hurts most.
  5. Run old and new side by side for a period, and compare totals and report outputs.
  6. Choose a cutover date, freeze the old file as read-only, and keep it available.

Where Ciscom fits

Ciscom has real experience with Microsoft Access, and we build custom web apps from scratch that run on phone, tablet and computer. That is the right choice only when the options above fall short, so we are happy to tell you if moving the tables or trying Power Apps would do the job.

Questions

Questions about replacing Access

Can I run Access on a Mac or in a browser?

Access is a Windows desktop program. People on Macs typically reach it through a virtual machine or a remote desktop. There is no current browser version of Access itself, which is often what prompts the move.

How many people can use an Access database at once?

Microsoft lists 255 concurrent users as the limit, though in practice shared files slow down and risk corruption long before that. If several people edit all day, moving the tables to a server is the usual first step.

What happens to my Access reports?

SSMA moves tables and data, not forms and reports. If you keep Access as the front end, your reports stay and read from the new server. With any other option, they have to be rebuilt, so list the ones you truly need.

Have an Access database that has run its course?

Tell us what yours does and who relies on it. You’ll get a written quote, and you’ll see a free demo of a first version before deciding.

Get a free demo