HOMEBookConferencesOpenOffice.org MacrosDatabaseSpamPerlMy Perl UtilitiesVYMMiscMagic

Database access using OpenOffice.org

It is my experience that database access is not well understood as it relates to OpenOffice.org (OOo). A book has been released named Database Programming with OpenOffice.org Base & Basic. I have only seen one chapter of the book, but there was certainly some very good information in the book, and it is worth a good read.

I consolidated my documents

I merged my Binary fields document (November 14, 2005 01:03:16 AM EST) with my Associated Data Text Document (November 22, 2005 11:39:08 PM EST) into my AndrewBase document (August 13, 2013 12:32:20 AM EDT).

My Main Downloads

Document Updated Description
Random DB Ramblins August 13, 2013 12:32:20 AM EDT This is my primary database document. Learn how to access Base document using macros. A lot of material using the GUI is also present.
PDF Ramblins August 13, 2013 12:32:20 AM EDT This is my primary database document. in PDF form.
First Sample Database September 10, 2005 11:36:32 PM EDT This is the first sample database, which demonstrates a Combo-Box. I think that it is broken, I can not remember.
Calc As A Simple Database September 3, 2006 01:42:40 PM EDT Tutorial and HowTo document for using Calc functionality that is similar to a database document. Most examples demonstrate how to solve the problem using the GUI and using a macro.
Associated Data Database November 22, 2005 11:38:59 PM EST Related Base document that demonstrates everything in the text document.
Stuff_We_Own_Sample.odb October 9, 2008 12:43:48 AM EDT Sample inventory that demonstrates how to store and retrieve image files. The complete database is explained in AndrewBase.

Useful Macro Links

There is a wealth of information available on-line that help decrypt the initially difficult paradigm. Here are some links and references:

Document Description
HSQLDB HSQLDB is the database embedded into OOo.

Valid XHTML 4.0! Last Modified July 5, 2010 09:59:16 AM EDT© 1999-2016 Andrew Pitonyak (email me at: andy @ pitonyak.org)