Open Source Alternative to MS Access

The open source alternatives to MS Access that I have looked at over the years did not match my favourite database’s full set of features.

A new offering is Kexi, which is a Free/Libre and Open-Source integrated data management application. Kexi is a long awaited Open Source competitor for products like Microsoft Access. Kexi can be used for creating database schemas, inserting data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries and forms – are stored in the relational database, making it easy to share data and design.

Unfortunately, although Python and Ruby programming languages are supported (beta stage) and JavaScript support is in development, scripting is not yet available on the Windows version.

I do not think I could live without VBA. It makes Access what it is for me. Here is a link to the scripting info for Kexi.

For now, I have to sit in the wings, until the scripting is ported to the Windows version of Kexi.

Leave a Reply