LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 03-03-2004, 09:06 AM   #1
j0217995
Member
 
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Rep: Reputation: 15
Question Linux and Microsoft Access Databases


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
 
Old 03-03-2004, 09:33 AM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 18,622

Rep: Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709Reputation: 2709
OpenOffice can be used as a frontend for SQL databases such as PostgreSQL and MySQL.
 
Old 03-03-2004, 11:07 AM   #3
danslinuxbox
LQ Newbie
 
Registered: Mar 2004
Posts: 7

Rep: Reputation: 0
that is useful to know

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

Ciao
Dan
 
Old 03-03-2004, 11:29 AM   #4
j0217995
Member
 
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Original Poster
Rep: Reputation: 15
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.
 
Old 03-03-2004, 12:05 PM   #5
j0217995
Member
 
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Original Poster
Rep: Reputation: 15
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.
 
Old 03-03-2004, 06:54 PM   #6
JoAnywhere
Member
 
Registered: Oct 2003
Location: denver
Distribution: Debian
Posts: 97

Rep: Reputation: 15
Access?

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
 
Old 03-04-2004, 07:34 AM   #7
j0217995
Member
 
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Original Poster
Rep: Reputation: 15
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.
 
Old 03-04-2004, 11:08 AM   #8
JoAnywhere
Member
 
Registered: Oct 2003
Location: denver
Distribution: Debian
Posts: 97

Rep: Reputation: 15
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
 
  


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 On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Source program that will handle MSS access 2k databases? rwhunt SUSE / openSUSE 3 12-02-2005 09:58 AM
Microsoft Access with Linux Red Hat munna_502 Linux - Software 3 08-25-2004 04:16 AM
how to access microsoft mdb in redhat linux 8 kjsubbu Linux - Software 8 06-02-2003 04:26 PM
microsoft access migration to linux mannybabe Linux - Software 2 04-07-2003 10:47 PM
ODBC Microsoft Access for Linux gokussj Linux - General 6 08-01-2002 04:54 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 11:08 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration