There is an Access Equiv. for Linux!

[ferreter]

Hello all,

I read an article today about an equivalent of MS Access for linux as a part of Open Office at article (http://www.linuxworld.com/2003/0207.barr.html)

Take a note of the comment section for ways to get it to work on Debian in like 6 commands.

Toodles!

[saithan]

I have gotten it to work well in Redhat 7.3 without issuse beyond the short commings of UnixODBC. I persoannly had a pain in the A$$ time getting it working the first time I tried. But after many trial and error sessions it is now a breaze.

[ferreter]

Is the program w/ openoffice any good? I haven't had the opportunity to install it yet as I'm not at home. That was one of my biggest beef w/ linux was its lack of a good access like program for editing databases.

[saithan]

well keep in mind that mysql is way far more superior to access and many functions native to sql is not all included with UnixODBC.

here was the same discussion from another post.

http://www.justlinux.com/forum/showthread.php?s=&threadid=86700&highlight=access

[matrixcubed]

What would be interesting is an Access-ish front-end for a MySQL database :)

[saithan]

um I think that was what we were explaining.
there is a access-ish way to handle Mysql through Open Office and other ways.
read the link to the other post ^^

[mdwatts]

With help from the article ferreter posted and the "OpenOffice.org 1.0, ODBC, and MySQL 'How-to'", I managed to get ODBC and MySQL working with OpenOffice (Writer).

Luckily SCO Linux (UnitedLinux) already included all the necessary MySQL packages and unixODBC as all I had to do was configure odbc.ini, odbcinst.ini and create a symlink.

ln -s /usr/lib/libodbc.so.1 /usr/lib/libodbc.so

I then setup the Data Sources in OO Writer and it worked.

Thanks ferreter for providing the link to the article. I now have another I can add to the list of Linux functions to present to the executives at work.

[kotj.mf]

I've yet to manage to get OOo to work with ODBC, but prolly because I've been taking too many shortcuts.

Anyway, you might want to check out MySQL Control Center from http://www.mysql.com. I got it up and working this morning in ten minutes flat.

Check it out:

http://neussubjex.net/misc/mysqlcc.png

[mdwatts]

Originally posted by kotj.mf

Anyway, you might want to check out MySQL Control Center from http://www.mysql.com. I got it up and working this morning in ten minutes flat.

Check it out:

http://neussubjex.net/misc/mysqlcc.png

I will... Thanks.

All this MySQL etc. testing is for work as Linux is now in our not so distant future plans. :D

[saithan]

I just tried mysql control center,

Very sweet interface. works great...
thanks for that post kotj.mf.
tools like that is what I like to see. with that mysqlcc I can remove the other sql fronts I have as it will cover th jobs better than them.

[kotj.mf]

Glad I could help.

Not to knock OOo or anything, but there comes a time in every man's life when he needs to get actual work done instead of fooling with his system. I've gotta get about 500 8pt, single spaced, double-sided pages transcribed an into a DB in three weeks, and mysqlcc will do nicely.

I hear that OOo 1.2 (?) is supposed to have tighter MySQL integration.

[torque2k]

FYI, this is a small article on the trials and tribulations of installing to a RH 8 system:

http://www.linuxworld.com/2003/0207.barr.html (LinuxWorld article)

[mdwatts]

Originally posted by saithan
I just tried mysql control center,

Very sweet interface. works great...
thanks for that post kotj.mf.
tools like that is what I like to see. with that mysqlcc I can remove the other sql fronts I have as it will cover th jobs better than them.

I did download mysqlcc today at work though I didn't have time to install yet.

Looks to be exactly what I need to modify a software inventory database I installed, but need to customize by removing some of the tables we do not need and then to ensure everything still works after.