Open Source Microsoft Access Alternatives

The best open source alternative to Microsoft Office Access is DBeaver. If that doesn't suit you, our users have ranked more than 50 alternatives to Microsoft Office Access and many of them is open source so hopefully you can find a suitable replacement. Other interesting open source alternatives to Microsoft Office Access are LibreOffice - Base, NocoDB, Baserow and Grist.

Microsoft Office Access alternatives are mainly Database Managers but may also be Spreadsheet Apps or Task Management Tools. Filter by these if you want a narrower list of alternatives or looking for a specific functionality of Microsoft Office Access.

Microsoft Office Access alternatives page was last updated

Microsoft Office Access

Paid • Proprietary
Database Manager
Windows

Microsoft Access, part of the Microsoft Office Suite, is a database management system for Windows that combines the...

Learn more about Microsoft Office Access

DBeaver
Is this is a good alternative?
Yes
No
Freemium • Open Source
Database Manager
Mac
Windows
Linux
Eclipse
Java
151 DBeaver alternatives
DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source universal database tool for developers and database administrators.
- - DBeaver is the most popular Windows, Mac & Linux alternative to Microsoft Office Access.
- - DBeaver is the most popular Open Source & free alternative to Microsoft Office Access.
Suggest and vote on features
DBeaver Features
1. AutocompletionDBeaver can predict and complete the rest of a word or phrase you're typing.
2. Dark ModeDBeaver supports dark mode for comfortable usage in low light conditions.
3. Built-in viewerDBeaver shows you a quick preview of an image, page or file in supported formats.
4. No registration requiredYou can use most of the features in DBeaver without registration.
5. Ad-freeDBeaver doesn't contain any form of external advertising.
6. PortableDBeaver can be used from a USB stick or similar with no prior installation.
Data export/import
Multiple DataBase
PostgreSQL support
ER Diagrams
Clean design
Desktop Application
SQLite
Restore on reboot
Support for Oracle
Export to CSV
LibreOffice - Base
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Mac
Windows
Linux
BSD
PortableApps.com
73 LibreOffice - Base alternatives
Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users, for all kinds of usages, such as keeping track of collections of objects,maintaining customer information databases,maintaining student grade and curriculum...
Suggest and vote on features
LibreOffice - Base Features
1. PortableLibreOffice - Base can be used from a USB stick or similar with no prior installation.
2. Extensible by Plugins/ExtensionsLibreOffice - Base can be extended with add-ons, plugins and extensions.
3. Ad-freeLibreOffice - Base doesn't contain any form of external advertising.
Test management
Multiple languages
PostgreSQL support
Comments about LibreOffice - Base as a Alternative to Microsoft Office Access
Most users think LibreOffice - Base is a great Microsoft Office Access alternative.
all • positive • negative relevance • date
Guest
LibreOffice is the most popular office suite on Linux and the open source community. It's completely free and open source, while the latest version of Microsoft Access requires a subscription. Based on OpenOffice Base, LibreOffice Base is a popular alternative to Access.
Top positive comment•
2

Guest
Libre Office is far from MS Access. You may connect to db servers, yes, but it's not possible to design and present a well structured user interface like an commercial application, and also, the programming language, and the interface aren't enough developed to achive the strenght and the power of MS Access. (I'm a OS Lover, but I'm sorry, Access is enough one of the mosts powerful user database, which any developer may deploy wide and very strong applications.)
Top negative comment•
18

Guest
I have used this product in the past, and there are really no templates, or the templates are from the community and that is just not good enough.
Negative comment•
-1

Guest
Microsoft Access is for Small businesses looking to create a database without a server. Base just can't compete with that function; it's more of a glorified spreadsheet.
Negative comment•
4

Guest
LO Base does lack huge amount of user-friendly functionality which MS Access has. It is more like a LO-Writer based front-end. Very much (and very much common) tasks can only be done by including macro-code, so you have to be quite skilled in programming Base. For that it's not a good alternative to MS Access, except you just want to do simple tasks. For any more complicated tasks it's just very time-consuming.
Negative comment•
14

Show more comments ▾
5 of 6 comments
NocoDB
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Spreadsheet App
Team Collaboration Tool
Self-Hosted
113 NocoDB alternatives
NocoDB is a feature-rich, open source #NoCode platform that turns any database into a smart spreadsheet similar to Airtable.
- - NocoDB is the most popular Self-Hosted alternative to Microsoft Office Access.
Suggest and vote on features
NocoDB Features
1. Kanban BoardNocoDB allows you to organize your workflow by moving cards with drag-and-drop functionality between multiple columns.
2. Works OfflineNocoDB can be used without the need to connect to the internet.
Whatsapp integration
S3 integration
Customizable
Twilio integration
Baserow
Is this is a good alternative?
Yes
No
Freemium • Open Source
Database Manager
Spreadsheet App
Task Management Tool
Online
Self-Hosted
Software as a Service (SaaS)
38 Baserow alternatives
Connect data, people, and workflows under one open source platform that gives you the freedom to create, the flexibility to scale, and fearless ownership over your data.
- - Baserow is the most popular SaaS alternative to Microsoft Office Access.
Suggest and vote on features
Baserow Features
1. Kanban BoardBaserow allows you to organize your workflow by moving cards with drag-and-drop functionality between multiple columns.
2. No TrackingBaserow will not track you or use your personal data.
3. Gantt-chartsBaserow allows you to visualize your project plan through a timeline with schedule bars and keep track of the work done.
4. Privacy focusedBaserow is considered a privacy friendly alternative.
5. Import CSV DataBaserow can import data from a CSV (Comma seperated values) file.
6. Real time collaborationMultiple users can work together in Baserow simultaneously.
7. Ad-freeBaserow doesn't contain any form of external advertising.
8. Extensible by Plugins/ExtensionsBaserow can be extended with add-ons, plugins and extensions.
9. Calendar ViewBaserow has a built-in calendar view to have a clear overview of your content over time.
API Integration
Git Support
No registration required
Hierarchical Structure
Decentralized
File Versioning
Grist
Is this is a good alternative?
Yes
No
Freemium • Open Source
Database Manager
Spreadsheet App
Mac
Windows
Linux
Online
Software as a Service (SaaS)
15 Grist alternatives
Combine the flexibility of a spreadsheet with the robustness of a database to organize your data, your way.
Suggest and vote on features
Grist Features
1. Import CSV DataGrist can import data from a CSV (Comma seperated values) file.
2. Dark ModeGrist supports dark mode for comfortable usage in low light conditions.
3. Real time collaborationMultiple users can work together in Grist simultaneously.
Cross-references
REST API
Excel formulas
Linking capability
Diff detection
Dockerized
Export to CSV
Symphytum
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Spreadsheet App
Mac
Windows
Linux
36 Symphytum alternatives
Symphytum is a personal database software for everyone who desires to manage and organize data in an easy and intuitive way, without having to study complex database languages and software user interfaces.
Suggest and vote on features
Symphytum Features
1. Import CSV DataSymphytum can import data from a CSV (Comma seperated values) file.
2. PortableSymphytum can be used from a USB stick or similar with no prior installation.
3. Cloud SyncSync your data (notes, documents, bookmarks, etc.) across your different devices and to the cloud.
Graphical User Interface
Data export/import
Dropbox integration
Sync with Dropbox
Personal Information Manager (PIM)
Discontinued
The GitHub repository is archived, no longer maintained.

Comments about Symphytum as a Alternative to Microsoft Office Access
Some users think Symphytum is a great Microsoft Office Access alternative, some don't.
Guest
Missing lot functionalities
Negative comment•
0

Guest
It is a good portable software for simple table create, data entry. It is better if it can provide more on query for different field.
Positive comment•
0

Guest
It doesn't open Access DB files to convert
Negative comment•
-3
DbGate
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Mac
Windows
Linux
Online
147 DbGate alternatives
DbGate is cross-platform database manager. Simple and effective, allowing to work with many various databases simultaneously - SQL and NoSQL.
Suggest and vote on features
DbGate Features
1. Ad-freeDbGate doesn't contain any form of external advertising.
2. AutocompletionDbGate can predict and complete the rest of a word or phrase you're typing.
3. LightweightDbGate consumes less device resources compared to similar apps.
4. Import CSV DataDbGate can import data from a CSV (Comma seperated values) file.
5. Dark ModeDbGate supports dark mode for comfortable usage in low light conditions.
Support for MS SQL Server
ER Diagrams
MongoDB
SQLite
Visual Query Builder
Support for MariaDB
nuBuilder Forte
Is this is a good alternative?
Yes
No
Free • Open Source
Online
Self-Hosted
24 nuBuilder Forte alternatives
Low-code, open-source RAD development tool for creating web-based database applications.
Suggest and vote on features
nuBuilder Forte Features
Web-Based
Report Builder
Formula Builder
Master Details forms
User Management
Single File Backup
Comments about nuBuilder Forte as a Alternative to Microsoft Office Access
Most users think nuBuilder Forte is a great Microsoft Office Access alternative.
StevenCopley
nuBuilder Forte is a great alternative to Microsoft Access.

It is open-source, web-based and has similar features like...

A Form Builder with the ability to "drag and drop" Objects.

A Report Builder with the ability to "drag and drop" Objects.

SQL Builder.

Format Builder for dates and numbers.

And just like Access, a whole application can be backed up by copying 1 file.
Positive comment•
5
Guest
Is not a desktop all-in-one database product. Must be used online and can't be used offline.
Negative comment•
-2
VFront
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Mac
Windows
Linux
Online
76 VFront alternatives
VFront is a dynamic front-end for MySQL or PostgreSQL databases written in PHP and Javascript. With VFront you can create forms for manage your data in AJAX style, different rules and privileges for groups, report in XML,HTML,PDF,statistics and much more.
Suggest and vote on features
VFront Features
Web-Based
SQLite
Opinions about VFront as a Alternative to Microsoft Office Access
Some users think VFront is a great Microsoft Office Access alternative, some don't.
Kexi
Is this is a good alternative?
Yes
No
Free • Open Source
Database Manager
Windows
Linux
26 Kexi alternatives
Kexi is considered as a long awaited Open Source competitor for Microsoft Access, Filemaker and Oracle Forms.
Suggest and vote on features
Kexi Features
KDE
Data-management
Comments about Kexi as a Alternative to Microsoft Office Access
Most users think Kexi is a great Microsoft Office Access alternative.
Guest
Crashes often, lacks much of the same functionality
Negative comment•
3