I need to convert a database from MS Access to something I can use in Linux. (In a moment of weakness I took over as Secretary for a club I belong to) I need data base functionality, like views and queries etc. I had the Access db file exported in excel format, opened it in OOo and then opened base and imported it as a dBase format file. Then I created a form using the form wizard. The data is all there. However when I go to open the file it always wants to create a form again. I read (in a book on OOo) that this is standard and that I should go to another OOo function, like Writer, and use File Open to open the file. But when I do that I get a Calc spreadsheet.
I have been trying to find documentation on the base function, with no luck. I have two books on OOo, but the sections on base are way too simplistic, and anyway doesn't seem to match my results. I went to the OOo web site but the documentation for OOo 2.x does not include base documentation.
How do I set up and use queries and views in base? How do I create input forms? I can't get to the form I created when I first imported the data.
Also, what is the dBase format? Is it the old DOS dBase format? Or is it a new linux relational format. The DOS dBase format was not a true relational data Base, I believe it was a linked list of some sort (I used to do a lot of xBase stuff in DOS but I've forgotten some of the particulars) Can I change the base dBase format to a true relational data base format like mySQL?
And does anyone know where I can get solid documentation on base?
Any help will be GREATLY appreciated