"FileMaker, Airtable or Access?" — this question comes up constantly in the searches of companies that want to move beyond Excel without launching a traditional development project. The three names often appear in the same conversation, as if they were three variants of the same tool. They are not: they come from different philosophies, serve different audiences and, above all, have different limits that are not always visible at first click. This comparison takes an objective look at what really sets them apart, in a particular context: FileMaker has just received, in 2026, for its 40th anniversary, its most important update in several years.

Three tools, three different philosophies

Before comparing specific criteria, each tool needs to be placed back in the context it was originally designed for.

Microsoft Access was launched in 1992 with Windows 3.1 (Wikipédia): a desktop database application, sold with some Microsoft 365 plans, originally designed for individual use or small groups on a local Windows network. It remains very common in companies that have used it for a long time, but Microsoft has gradually reduced its place in its cloud offers since 2022, now concentrating its investment on the Power Platform rather than on Access itself (ASCI).

Airtable is the most recent: a no-code tool that emerged from the collaborative spreadsheet lineage. It looks like a cross between a spreadsheet and a database, with multiple views (grid, kanban, calendar, gallery) and built-in automations. It is designed for teams of a few people to a few dozen people who want to organise operational data quickly — a lightweight CRM, project tracking, an editorial calendar — without any particular technical skills.

FileMaker, published by Claris (an Apple subsidiary), is in fact the oldest of the three: its development began as early as 1986 (Wikipédia). We are now at version 2026, proof of a durable piece of software. Functionally, it sits at an intermediate level: further than a simple database tool like Access or a no-code tool like Airtable, but without requiring fully coded development like software built from scratch. It is a low-code development platform (I would be tempted to invent the term "mid-code") that lets you build a genuine custom business application — screens designed for a specific use, advanced automations (scripts), native mobile access through FileMaker Go.

What really sets them apart

The choice between the three is rarely decided on appearance or on initial ease of use, which are fairly similar. It comes down to a handful of criteria that only become visible as usage grows.

Volume and performance. Access is capped at 2 GB per database (minus the space needed for system objects), with a theoretical maximum of 255 concurrent users — a figure that, in practice, rarely matches a smooth experience beyond a few dozen real users (Microsoft — Spécifications d'Access). Airtable, for its part, starts to slow down noticeably beyond 50,000 records per base — filters and views that take several seconds to load — and becomes hard to recommend beyond 125,000 records (Nocode Factory). FileMaker, built on a genuine relational database engine, does not have this kind of ceiling for standard business use. A single file can reach 8 TB, contain up to 1 million tables and up to 6.4 × 1016 records over its lifetime. So, there is a little headroom (Claris).

Multi-user access and availability. Access was designed for local network access, not for continuous availability online: beyond a small number of simultaneous users, locks and slowdowns become frequent (ASCI). Airtable handles real-time collaboration well for modest-sized teams, with a genuinely comfortable day-to-day experience (Hack'celeration). FileMaker, hosted on a dedicated server, was designed from the start for simultaneous, continuous multi-user access. In 2026 it adds two notable features for service continuity: an encrypted automatic backup every 20 minutes, and a standby server (Standby Server) able to take over within minutes if the primary server fails (Claris).

Mobility and offline use. Access remains a desktop tool, with no real native mobile version. Airtable has mobile apps, but advanced field use (custom forms, built-in photo capture, offline operation) most often requires third-party tools on top. FileMaker natively offers FileMaker Go, a dedicated app for iPhone and iPad that lets you use the application you have developed on mobile, including for field data entry. Sorry to owners of smartphones running other systems.

Business depth and customisation. This is where the three tools diverge the most. Access lets a developer familiar with the Microsoft ecosystem build fairly advanced forms and queries, but it remains limited when it comes to advanced automation or an interface designed specifically for one line of business. Airtable covers data organisation needs well, with links between tables (linked records) and automations that handle a good share of common needs, but without strict relational integrity constraints and with fairly limited native charts, often requiring a third-party reporting tool to go further (Nocode Factory, Hack'celeration). FileMaker lets you build screens, automations (scripts) and business logic as sophisticated as necessary, with the option of going all the way down to code for advanced needs — at the price of a longer learning curve than the other two tools.

Hosting and GDPR compliance. Access, used locally or on a company network, does not raise a hosting question as such. Airtable hosts its data on AWS servers in the United States by default; data residency in Europe is only offered on the Enterprise plan, a point of vigilance for companies subject to strict GDPR requirements that do not have that plan (Nocode Factory). FileMaker, for its part, can be hosted wherever you choose: in-house, with Claris (FileMaker Cloud), or with a specialist French hosting provider — which leaves the company free to decide where its data is located.

Cost. Access is generally already included in certain Microsoft 365 plans, which makes it the cheapest option to acquire for a company that is already equipped — but without the capabilities of the other two tools. Airtable works on a monthly subscription per user: free up to 1,000 records, then around $20 per user per month on the Team plan (50,000 records), and $45 per user per month on the Business plan (125,000 records) — a model that becomes expensive beyond about ten users (Nocode Factory, Hack'celeration). FileMaker also works on a subscription basis, and there are many variants. The price is degressive per unit, in tiers: 10, 25, 50, 100, 250, 500 and 1,000 users. You can also own your version outright, but in that case you stay frozen on the version you bought, unless you take out an annual maintenance contract. The cost remains higher than Access, but it pays for a complete development platform rather than a simple data organisation tool.

FileMaker 2026: what the latest version changes

The 2026 news makes the comparison particularly relevant. In June 2026, for the platform's 40th anniversary, Claris released FileMaker 2026, an update marked less by a single flagship feature than by overall consistency across several fronts (Direct Impact Solutions).

On the artificial intelligence side, FileMaker 2026 adds support for Google Gemini to the models already available (Anthropic, OpenAI, Cohere), with dedicated metadata calculation functions ("BaseTableComment", "FieldAnnotation") that allow more precise natural-language queries and finer semantic search within the application's data (Claris). The first building blocks of agentic development — an environment integrated with AI tools to assist the developer directly — are announced for summer 2026.

On the service continuity side, the two features already mentioned above — an encrypted automatic backup every 20 minutes and a fast-failover standby server — are aimed squarely at companies for which even a short outage of the application has a real cost. On the development side, a redesigned Inspector (far from a success), collapsible script comments, dedicated folders for custom functions and a new XML tool for version control make teamwork easier on larger FileMaker projects (Claris, Direct Impact Solutions).

This update illustrates a difference in trajectory between the three tools: where Microsoft now invests primarily in the Power Platform rather than in Access (ASCI), Claris continues, 40 years after FileMaker's launch, to evolve the platform in depth — a useful signal for a company that thinks in terms of a multi-year investment rather than a one-off solution.

Which tool for which situation?

Access remains defensible for individual use or for a very small team, in-house, on a local network, when the company already has the licence through Microsoft 365 and its needs will not grow towards more users, mobility or automation. It is a default choice rather than a strategic one — to be reassessed if usage grows.

Airtable suits a team of a few to a few dozen people who need to organise operational data quickly — project tracking, lightweight CRM, editorial calendar — without technical skills, with genuine day-to-day comfort thanks to its multiple views. It shows its limits as soon as the volume of data grows significantly, when compliance requirements call for European hosting on every plan, or when the business logic becomes too specific for standard automations.

FileMaker is the best fit when the application must become a real internal management tool, expected to evolve over several years, with needs for a tailor-made interface, advanced business logic, mobile field access, or critical service continuity. It is also the option that leaves the most freedom over hosting and data location, a point that matters for companies subject to strict compliance requirements.

What to remember

There is no best tool in absolute terms, only a tool better suited to a given context. Access remains relevant for simple individual use, but its future at Microsoft is increasingly uncertain. Airtable is excellent for quickly organising team data, but quickly reaches its limits as volume, business logic or compliance constraints increase. FileMaker demands a larger investment at the start, but remains the only one of the three designed to become, over time, a genuine business application — a choice that the platform's 2026 news (AI update, strengthened service continuity) only reinforces.

The right reflex, before choosing, is to start from the trajectory of your need rather than its current version: if you already imagine that your usage will grow in volume, number of users or complexity over the next two to three years, it is better to choose straight away the tool that can keep up with that growth, rather than one day having to migrate a system already in place.

Sources

A question? A project to study?

20 - 6 =
hCaptcha *

Contact us

Please complete the form.
See our Contact page to contact us directly. 

Logo Claris Partner

Logo Claris MarketPlace

Logo Claris Partner Reseller

Copyright ©2020-2026 IU-DATA | All rights reserved | Legal Notices | Privacy Policy | Terms and Conditions | Designed by inPhobulle