Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 12-31-2003, 06:37 PM   #1
Registered: Oct 2003
Posts: 47

Rep: Reputation: 15
Question Database software, equivalent to Access?

I'm just wondering if Linux has a database app that runs on the desktop equivalent to Access? Something that has the simple GUI for joining tables and building queries. Something programmable in the same manner as Access with modules, forms and savable queries. I'm just curious as I use Access a lot at work but am interested in alternatives.

Old 12-31-2003, 07:08 PM   #2
Registered: Oct 2003
Location: Twin Cities
Posts: 32

Rep: Reputation: 15 has a database feature..

Hope this helps!
Old 12-31-2003, 07:09 PM   #3
Registered: Aug 2002
Posts: 16,025

Rep: Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850Reputation: 1850
OpenOffice has something similar. The OO database is just a front end for relational database servers like PostgreSQL and MySQL.
Old 12-31-2003, 08:00 PM   #4
Senior Member
Registered: Nov 2001
Location: Budapest, Hungary
Distribution: SuSE 6.4-11.3, Dsl linux, FreeBSD 4.3-6.2, Mandrake 8.2, Redhat, UHU, Debian Etch
Posts: 1,126

Rep: Reputation: 58
PostgreSQL is an SQL server having most of the SQL features MSAccess has, only it is much faster. But it is only the database engine, it has no GUI interfaces.
There are some GUI interfaces designed to work with PostgreSQL, but I think they have much less features than the GUI of MSAccess.

As for OpenOffice's database front-end capability: very modest.
It may be OK for entering data into one single table of a database at a time, or to view the results of complex queries (based on several related tables), but it is far from being suitable to enter data into a complex relational database, where you would possibly use forms and sub-forms.
I must say, even StarOffice 5.2 had a better database interface than OpenOffice 1.0. In StarOffice 5.2 there were only a few misfunctions (possibly bugs) that prevented me from reproducing a complex MSAccess database interface, while with OpenOffice 1.0 I was stucked at the beginning of the work by serious bugs and misfunctioning related to Form handling.
Old 01-01-2004, 08:35 AM   #5
LQ Newbie
Registered: Jan 2004
Posts: 2

Rep: Reputation: 0
I think the program which comes closest to M$Access is Rekall from theKompany.
It does not provide the database but can connect to all the usual suspects (mySQL, postgres, odbc etc.) and provides forms, scripting in Python and reports. I looked at it some months ago and found it intuitive (very access-like) but didn't have a real project to test it with. It was a pain to install on Debian at that time so I tested the windoze version. I don't know how install-friendly it has become in the meantime.

The software is dual licensed - commercial and GPL.
The sources to the GPL version are freely available from
Ready-to-install binaries however will cost you 15 British Pounds. For evaluation purposes you might want to download a trial version of the commercial package from .
After installing the trial version on windoze I had problems trying to install the GPL version so you might want to use a de-installer tool or use a windoze box which you do not care about.

Have fun and if you give it a bash I would be very interested to hear how you get on.

Richard Sullivan
Old 01-04-2004, 06:54 PM   #6
Registered: Oct 2003
Posts: 47

Original Poster
Rep: Reputation: 15

It might be a while before I get to try any of them. I'm pretty busy trying to set up postfix at the moment but I eventually would like a nice Access like query builder for Linux with that ability to work with joined tables. Thanks for the advice all!


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Software equivalent to PaperPort on Win satimis Linux - Software 2 12-28-2005 10:49 AM
MS Access Equivalent djib Debian 2 02-15-2005 11:06 AM
software equivalent in linux scng Linux - Software 1 09-04-2004 11:21 AM
Ms Access Equivalent???? graystarr Linux - Software 4 07-09-2002 08:21 AM
MS-Access equivalent.... frkstein Linux - Software 4 06-08-2002 12:00 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:31 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration