HOME	Book	Conferences	OpenOffice.org Macros	Database	Spam	Perl	My Perl Utilities	VYM	Misc

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 (July 28, 2009 09:57:56 PM EDT).

My Main Downloads

Document	Updated	Description
Random DB Ramblins	July 28, 2009 09:57:56 PM 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	July 28, 2009 09:57:56 PM 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.