After reading the rules for starting a new thread in this forum, I believe this is where best to ask this question.
I am relatively new to linux and decided the best way to really learn and understand it is to use it every day. I am running SUSE, simply for the easy of resizing my NTFS drive during setup and am enjoying it.

Ok finally getting on to my question.... I was recently asked as part of my job to help with designing an Access database. I can do this in Windows, my system dual boots, however I have not found a real easy way to do this in Linux. Is there an office program that works like Access that I can develop on my linux side? I have OpenOffice installed but did not see a database like program there.

Any help would be greatly appreciated, thanks in advance

OpenOffice can be used as a frontend for SQL databases such as PostgreSQL and MySQL.

that is useful to know

I looked up the link
http://www.openoffice.org/product/dbase.html

Ciao
Dan

I know they have a front end for MySQL and Postgres, what I am looking for is a way to use and access MS Access database in linux. Is it possible?
I have used Access before and am more advanced then a newbie in it. However I am brand new using and creating both MySQL and Postgres. I guess I could learn how to use them, but how easy would it be to create forms and tables and the like that I could do instead with Access.

Pardon the ignorance, but following the link shows the Database User Tools, but when I install OpenOffice through YAST, I do not see an option form the Database User Tools. Once again a pretty weak linux user so sorry if I'm doing something wrong.

I could of course be very cynical and ask why in gods name you'd want to use access for anything anyway?

Why not use a real database that is scalable, reliable, and standards based?

Sorry - I'm a long time DBA and Programmer, I have NO respect for access other than as a handy ODBC based reporting tool for letting users run reports on real databases!!!

Regards
Jo

I would love to use a better database then Access, but when you are the IT department in your company with a tight budget and already have access on all the computers and are asked for a quick and easy database to track some very basic things, all you have time to learn and train on is what they already use.
Besides that is off the topic and the question, still haven't found in real good solution. I would like the ability to create forms and tables that are linked and can easily be updated by anyone without having to learn too much new stuff.

One thing I did find after a little research was this
http://www.omnis.net
you might want to look at it. It appears to support ODBC/JDBC databases, Native connections to Oracle etc. This is good for shared access to databases etc.

Cheers
Jo