Connecting Open Office Base Appliction to SQL

“In my last article, Quick and Dirty with Open Office Base, I
described my initial experiences with building a simple database
application for my wife in Open Office Base, having had no prior
experience with the program. In that article, I described how easy
it is to get started, and how easy it is to build usable software
with Base. In this article, I’m going to discuss mitigating one of
Base’s major weaknesses by connecting it to an external SQL
back-end.

“Shortly after I finished the program and demonstrated it to my
wife, I encountered one of Base’s major limitations. I had put the
database file in a shared “Documents” directory so that
both she and I would have access to the program, and that’s when it
happened. I returned to my desk to work on the program and received
an error message indicating that the file was locked and couldn’t
be accessed. It turns out that Base doesn’t allow concurrent access
to a given database. This limitation doesn’t bode well for the day
when my wife’s business has millions of dollars in sales and
hundreds of employees! (Well, one can wish, right?)”

Complete Story