AlternativeTo Logo

Open Source Microsoft Access Alternatives

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

Microsoft Office Access alternatives are mainly Database Managers but may also be Spreadsheet Apps or Team Collaboration Tools. Filter by these if you want a narrower list of alternatives or looking for a specific functionality of Microsoft Office Access.
This page was last updated May 29, 2022
  • 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

  1. LibreOffice - Base

    • FreeOpen Source
    • Mac
    • Windows
    • Linux
    • BSD
    • PortableApps.com

    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...

    LibreOffice - Base vs Microsoft Office Access opinions
    Some users think LibreOffice - Base is a great alternative to Microsoft Office Access, some don't.

    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  over 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    2

    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  over 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    18

    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 8 months ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    -1

    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 over 3 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    4

    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 about 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    14

    Is a good alternative; even better because it uses common and more powerful databases like mysql or postgres

    Positive comment over 5 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    -6
  2. DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source (GPL) universal database tool for developers and database administrators.



  3. NocoDB is a feature-rich, open source #NoCode platform that turns any database into a smart spreadsheet similar to Airtable.

  4. 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.

    Discontinued

    The GitHub repository is archived, no longer maintained.

    Symphytum vs Microsoft Office Access opinions
    Some users think Symphytum is a great alternative to Microsoft Office Access, some don't.

    Missing lot functionalities

    Negative comment almost 2 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    0

    It doesn't open Access DB files to convert

    Negative comment over 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    -3

    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 over 2 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    0
  5. Grist

    • FreemiumOpen Source
    • Mac
    • Windows
    • Linux
    • Online
    • Software as a Service (SaaS)

    Combine the flexibility of a spreadsheet with the robustness of a database to organize your data, your way.



  6. Kexi

    • FreeOpen Source
    • Windows
    • Linux

    Kexi is considered as a long awaited Open Source competitor for Microsoft Access, Filemaker and Oracle Forms.

    Kexi vs Microsoft Office Access opinions
    Some users think Kexi is a great alternative to Microsoft Office Access, some don't.

    Crashes often, lacks much of the same functionality

    Negative comment almost 5 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    3
  7. Apache OpenOffice Base

    • FreeOpen Source
    • Mac
    • Windows
    • Linux

    Database management solution from OpenOffice.

    Most users think Apache OpenOffice Base is a great alternative to Microsoft Office Access.
  8. VFront

    • FreeOpen Source
    • Mac
    • Windows
    • Linux
    • Online

    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.

    Some users think VFront is a great alternative to Microsoft Office Access, some don't.
  9. Low-code, open-source RAD development tool for creating web-based database applications.

    nuBuilder Forte vs Microsoft Office Access opinions
    Almost everyone thinks nuBuilder Forte is a great alternative to Microsoft Office Access.
    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 over 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    5

    Is not a desktop all-in-one database product. Must be used online and can't be used offline.

    Negative comment about 4 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    -2
  10. Tiki Trackers is an Open Source database web apps builder. With Tiki Trackers you can easily build databases, web forms and reports to manage your data online with zero programming knowledge.

    Tiki Trackers vs Microsoft Office Access opinions
    pros, cons and recent comments
    fabiomontefuscolo

    It is an opensource solution to Microsoft Access. You can model, store, retrieve and plot your data in many ways, making possible to build valuable knowledge.

    Positive comment about 3 years ago
    Copy a direct link to this comment to your clipboard   
    If this Comment contains spam or other abuse, notify admins about it.

    1
Showing 10 of 19 alternatives