Is there database support in OpenOffice.org?
Yes, there most certainly is! Although in version 1 (the current version) of OpenOffice.org (OOo) there is no separate program which directly corresponds to Microsoft Access. (see the other FAQs for more detailed discussions) The component of OOo 1.x which deals with data (referred to as Base 1.x) can be a frontend to other external database applications (MySQL, postgreSQL, Oracle and so on) or to the built in dBase-format database system. Note that Star Office (the commercial, enhanced version of OOo) comes with Adabas D, a fully fledged relational database system. In the upcoming version 2 of OOo there will be an application component called Base 2.x which will offer a complete solution for database management. If you are interested in reading more about Base 2.x there is a detailed explanation of the direction of this project component on the DBA Project site.
Yes, there most certainly is! Although in version 1 (the current version) of OpenOffice.org (OOo) there is no separate program which directly corresponds to Microsoft Access. (see the other FAQs for more detailed discussions) The component of OOo 1.x which deals with data (referred to as Base 1.x) can be a frontend to other external database applications (MySQL, postgreSQL, Oracle and so on) or to the built in dBase-format database system. Note that Star Office (the commercial, enhanced version of OOo) comes with Adabas D, a fully fledged relational database system. In the upcoming version 2 of OOo there will be an application component called Base 2.x which will offer a complete solution for database management. If you are interested in reading more about Base 2.x there is a detailed explanation of the direction of this project component on the DBA Project site.
Yes, there most certainly is! There are several useful resources that will help you get going: • OpenOffice.org DBA Project – The official site, with useful FAQs and HOWTO guides to set you on the right track. • OpenOffice.org, unixODBC and MySQL – a great guide, tailored to Red Hat 9 mainly, but excellent when it comes to OOo integration with MySQL. Comes with screenshots too!
