Trail of Tears: MySQL, ODBC, & OpenOffice 1.0
Joe Barr writes "
I found a wonderful "how-to" piece called "OpenOffice.org 1.0, ODBC and MySQL," by John McCreesh. In the introduction, McCreesh writes about OpenOffice.org 1.0's "best kept secret" -- that secret being the fact that hidden away inside, completely unknown to most OpenOffice users, is a user-friendly front end for databases that is "a Microsoft Access (and more) equivalent." That may be so, but there is a very good reason why it's a secret: it's too damn hard getting OpenOffice and ODBC wired up correctly."
The first time I tried it I connected it both to MySQL and M$ Access inside of 15 minutes having never used either OpenOffice or ODBC before. It wasn't difficult at all. I didn't like it and went back to my own way of doing things but it wasn't difficult to setup. I'd say if you have trouble with the setup you really don't want to be messing with databases without a more experienced user to guide you. Try IRC or a mailing list - lots of help is available.
At what price learning? At what cost wisdom? The price is a man's peace of mind, and the cost is his life.