LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 12-31-2003, 07:37 PM   #1
nidputerguy
Member
 
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.

Thanks!
 
Old 12-31-2003, 08:08 PM   #2
johnallen
Member
 
Registered: Oct 2003
Location: Twin Cities
Posts: 32

Rep: Reputation: 15
OpenOffice.org has a database feature..

http://www.openoffice.org/dev_docs/f...1.1/index.html
http://www.openoffice.org/dev_docs/f...ages/dbase.jpg

Hope this helps!
 
Old 12-31-2003, 08:09 PM   #3
michaelk
Moderator
 
Registered: Aug 2002
Posts: 12,164

Rep: Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784
OpenOffice has something similar. The OO database is just a front end for relational database servers like PostgreSQL and MySQL.

http://www.openoffice.org/product/
 
Old 12-31-2003, 09:00 PM   #4
J_Szucs
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, 09:35 AM   #5
richardsullivan
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
http://www.rekallrevealed.org/module...download&cid=4
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 www.thekompany.com .
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, 07:54 PM   #6
nidputerguy
Member
 
Registered: Oct 2003
Posts: 47

Original Poster
Rep: Reputation: 15
Access

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!
 
  


Reply


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 11:49 AM
MS Access Equivalent djib Debian 2 02-15-2005 12:06 PM
software equivalent in linux scng Linux - Software 1 09-04-2004 12:21 PM
Ms Access Equivalent???? graystarr Linux - Software 4 07-09-2002 09:21 AM
MS-Access equivalent.... frkstein Linux - Software 4 06-08-2002 01:00 AM


All times are GMT -5. The time now is 03:59 AM.

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