We've just done a nice conversion job this morning and talked the school out
of spending a shed load of money on MS Office for 86 new machines and using
OpenOffice instead. Inevitably, real soon now, someone is going to ask about
doing 'Access' style stuff.
So, I've just had a play with a Windoze box here, installed MyODBC and set up
a datasource pointing to MySQL on one of my SuSE boxes. I fiddled around in
the datasources bit of OpenOffice and then, by pressing F4, I get into a mode
where I can see my database, fiddle about, run queries etc. For anyone
wanting to have a play, note that the above was extremely easy, and there
were no problems!
I have yet to work out if and how to use the data in a document or to connect
a form to it. Since my only use for Access is as an emetic, can anyone advise
me as to whether or not this is the same kind of stuff you do in Access, and
do we have a fairly close match on functionality?