Hi to all !

I am new to Linux ,and i was wandering : Is there any Database program in Linux Like Microsoft Access ? I mean i want to make a database but i dont know any database programming so a GUI database program is my only choise. Any suggestions ??

Thx in advance !

Umm, personally, I would use Oracle. It's harder to learn but a lot more reliable than Access.

I would definitely not use Oracle, especially if you are not interested in learning programming.

Unfortunately, I haven't run across anything in Linux that's quite as nice as Access. There are several powerful database systems, including Oracle, as well as free alternatives such as MySQL and PostGreSQL, but as far as a nice GUI database, they can be hard to find.

I'd say it partly depends on how many of Access's features you actually used, though. If you want something that has the full potential to create a graphical front-end for your databases, along with the VB-style event handling, functions, and so on, you may be better served by learning how to set up and configure one of the powerful SQL databases mentioned above. You'll probably need to learn SQL, at the very least, to do anything very useful with a database.

If you're more interested in just having a simple row/column database for keeping track of your CD collection or whatnot, you could probably find a specialized database with a GUI for your particular purpose.

Check out this article on Freshmeat, which may address some of your questions.

Well Wap,

Yeah, he could use Access if he wants to go with M$ crap. I have begun to hate M$ with a vengeance. Almost as bad as Daryl McBride but not quite as much. And another thing you're not even considering is how would access run on a LInux box in the first place?? I only suggested Oracle because as I understand it, most large companies that have databases use Oracle. I could be wrong but that's what I have been told to understand.

I have not tried or personally used this, but it seems to a GPL version of an Access-like DB frontend

http://www.rekallrevealed.org/

HTH
Steve

OpenOffice plans to have one in their 2.0 release, although thats not coming around until 2005...so i guess my comment is not of much use...

If you install MySQL which is a pretty good data base, It will get done what you want. If you want a gui interface ( I use it all the time) Go to MySQL's site and download the control center. It looks allot like the MS SQL enterprise manager. Its a great way to create your data bases and tables without knowing the command line options. Give it a try it will work for you.

on that note, phpmyadmin does the job very well too, if you just need the gui for creating, viewing, maintaining the databases, tables, and records...

I had the same problem.. Solved it by using StarOffice (currently using the older 5.2 version). I set up a simple db database and imported my Access files. Was a snap. If you decide to go this route and need help, let me know and will be glad to assist.

I don't recall suggesting that using Access was a good idea, nor that it was a possibility, though apparently Crossover Office makes it fairly easy to run MS Office (including Access) under a modified version of Wine.

As for Oracle, to the best of my knowledge it is a rather pricey package. This place lists Oracle licenses for around $12,000 at discount; I have no idea what they actually cost, but it's certainly not cheap, and definitely not for the hobbyist. Sure, some large companies use Oracle, because they can afford it. A lot of other (in my opinion, smarter) companies use MySQL or PostgreSQL because they are free

Sybase's Linux products are often overlooked. They have much more in common with MS SQL Server than Oracle does, which makes transitioning painless. SQL Anywhere Studio is ideal for smaller companies and developers.
http://www.sybase.com/linux

Thx a lot men !!!!
You were very helpful to me !!

If you check out rekall, could you report back and let us know how it compares to access? I've been meaning to check it out, but being on dialup I've not had the chance to download it.

I have tryied to install rekall but i faced some critical problems during the installation so i gave up.
I think , i am going to learn MySQL.

>> I have tryied to install rekall but i faced some critical problems during the installation so i gave up.
>> I think , i am going to learn MySQL.

There is a slightly updated version of Rekall (released late December) which should be easier to compile (I found it much easier). There is also a precompiled trial version too if you want to try it. I am sure there will be freely available binaries appearing soon too (the source code makes it very easy to generate RPMs for various distros).