Access clone

[icronk]

I've been looking for an app similar to MS access. I've searched these forums and a couple of others and of course google. The only suggestions I've found are MySQL and PostgreSQL. I know these are very powerful databases but I haven't got a clue where to start with them or if they will work in a way similar to MS Access. I really don't know anything about SQL or anything like that so please forgive my igorance. If MySQL is a viable alternative to access then I'd love to learn how to use it, if it's over kill for creating small databases then i'd like to try something else.
Also if I were to use MySQL or PostgreSQL is there any other apps I would need to create databases other than the download from ther sites? And finally, if anyone knows a good resource to learn either of these databases (just to do small databases) i'd love to hear about it.
Thanks,

[mdwatts]

Why not try either MySQL or PostgreSQL's homepage as both have loads of online documentation.

My distro has online documentation on their site to help with the setup and configuration, plus all the docs installed with the apps.

I use Webmin to administer MySQL.

Google for Linux searching will find you all sorts of tutorials/guides.

[av8or]

First of all, unfortunately you will probably not find a viable alternative to MS Access. I was on this same quest a few months back. The only close alternative that I was able to find was the Adabas database that can be used as a part of StarOffice.

Secondly, MySQL and PostgreSQL are both DBMS's that are more like MSSQL. Actually in performance and reliability, I belive that it can be proven without a doubt that they will run circles around MSSQL.

However, if you are looking for a good database application for creating small, single user(or no more than a few) databases with decent looking frontends all in a single, fairly easy to use package then, MS Access will probably be right for you.

Please don't get me wrong, you can write some very powerful and large DB driven apps with the use of MySQL (or PostgreSQL) and a gui frontend development package. And these packages are becoming more prevalent and easier to use. I just don't think that they're the best fit for the small stuff.

Just my miniscule opinion..... Take from it what you will.

[icronk]

Thanks for the feedback. What 's a popular tool for creating gui frontends with MySQL? I think it's worth giving a try and probably fun to learn as well.
If anyone can suggest something it would be greatly appreciated.
Thanks