HOME	Book	Conferences	OpenOffice.org Macros	Database	Code	Spam	Perl	My Perl Utilities	4NT batch files	VYM

Database access using OpenOffice.org

It is my experience that database access is not well understood as it relates to OpenOffice.org (OOo). A new GUI for database related acess will be released with OOo version 2.0. I have started to document various aspects of Database usage with respect OOo, but I have not yet finalized the scope of the document. In other words, I have not decided if this will be another book that is published and sold, or if this book will be freely available as a document. My decision will determine how much time and efforts goes into the book. As I have more to say, I will post information on this page.

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 (February 18, 2008 12:54:51 AM EST).

My Main Downloads

Document	Updated	Description
Random DB Ramblins	February 18, 2008 12:54:51 AM EST	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	February 18, 2008 12:54:51 AM EST	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.

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.