At first sight this may seem to have nothing to do with Japanese animation, but read on…<\/p>\n
The OpenOffice suite is an alternative to Microsoft Office, and has the advantage of being free. OpenOffice 2.1 now includes a database, Base, which can potentially be used instead of MS Access.<\/p>\n
MS Access isn’t included in the entry level versions of MS Office because, to be frank, unlike Excel it’s a “developer” rather than a “user” program. The same applies to OO.org Base. I’ve tried to start a database development using Base and found that:<\/p>\n
1) it does work.<\/p>\n
2) It’s more clunky and awkward to use than Access and even when it can do things it can take some work to find out how. And I was not impressed by the Reports.<\/p>\n
The interesting thing, however, about Base is that it was inconspicuously included in the early OpenOffice packages before OpenOffice had its own database engine. So how did that work??<\/p>\n
To cut a long story short, Base can be used as a front end for any database engine, i.e. MS Access, MySQL, and lots of others, by linking to them as “data sources” with the aid of a suitable driver.<\/p>\n
If you are running a MySql database on your local computer or network, you could download Open Office here, <\/a><\/p>\n read the instructions here,<\/a> Once you have got this far, you can soon knock up a handy form that will let you inspect and add data to your MySql tables. And why is this useful to anime enthusiasts? You might have a MySql database on your website, and a mirror of it stored on your local computer.<\/p>\n A final, but important, tip. The import to Base isn’t perfect, and you may find that the form wizard won’t see some fields, e.g. your Blob text fields. Before you use the form wizard, look at your tables in Base, in the edit mode, and check that the field parameters make sense. e.g. change Image[Blob] to Memo[Mediumtext].<\/p>\n","protected":false},"excerpt":{"rendered":" At first sight this may seem to have nothing to do with Japanese animation, but read on… The OpenOffice suite is an alternative to Microsoft Office, and has the advantage of being free. OpenOffice 2.1 now includes a database, Base, which can potentially be used instead of MS Access. MS Access isn’t included in the … Continue reading “MySql & OpenOffice Base”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=\/wp\/v2\/posts\/38"}],"collection":[{"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":0,"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sandg-anime-reviews.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\ninstall the JDBC connector\/j driver downloaded from here<\/a>
\nand (if you have also installed the Java Runtime Environment), fire up Base and link to your named database.<\/p>\n