[KLUG Members] Open Office, database

Bruce Smith members@kalamazoolinux.org
28 Feb 2003 08:54:02 -0500


> 2. No database is included in Open Office.
> 
> Is there an open source database program that will work together with OO
> that is relatively user friendly?  We are working on Windows 98, 2000 and
> XP.  I know of PostgreSql and MySQL.  MySQL seems more of a back end
> database, I need something that the average user can put together mailing
> lists or employee time logs, etc.  Hopefully with a graphical user
> interface rather than SQL code.  The employees are familiar with Microsoft
> Access now.  Is there a front end to one of these open source database
> programs that would allow a somewhat inexperienced user to create tables
> and enter data?  Maybe Postgresql has something like this? phpMyAdmin
> might be a way to go, although it is pretty slow (over the net anyway) for
> data entry.

OpenOffice can connect to Postgresql or MySQL as a data source. 
(just press F4 in OO - after it's setup)  Even a nice GUI!  :-)

I've done it using Postgresql and the UnixODBC drivers on Linux.

Check out Adam's database presentation on the KLUG ftp server
as a good place to start.

--------------------------------------------
Bruce Smith                bruce@armintl.com
System Administrator / Network Administrator
Armstrong International, Inc.
Three Rivers, Michigan  49093  USA
http://www.armstrong-intl.com/
--------------------------------------------