It is a "data reader" that allow you to view and utilize data from other sources. So therefore, if you want to edit the "data" you need to go to the "source" and edit it there.
Yes, Base is a front end for a database engine, for an
Embeddded database its HSQLDB version 1.8 .
So if I go back to the spreadsheet that I created an address book from and add a column a new data field will appear in ODB. Is that correct?
No, you would need to use the process I described earlier to create a new table. Calc has no way of directly communicating any changes to the HSQLDB database engine.
However, Calc can use data supplied by the Base front end, as a Data source. When you press F4 on a Calc spreadsheet you will get a dialog that allows you to chose tables and queries from registered Base databases. Changes made to data in a database table can automatically show up on a spreadsheet, but, it doesn't work the other way around.
In an
Embedded database everything is stored in the .obd file, which is actually a zip archive with the tables, queries, forms and reports all stored in a compressed format. If something goes wrong with the zip process, an .obd file can become corrupt and all the data is lost! So, when using an
Embedded database, regular backups are extremely important.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional