Thanks, Alex, for the clarification. Since I have never used the internal hsqldb database, I was unaware that it kept its data in the .odb file. The last internal database I used was Adabas D in Staroffice. I quickly went to JDBC or ODBC connectors to other external datbase engines (e.g., MySQL). John
On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood <alex.thurg...@gmail.com>wrote: > On 11/03/2014 13:23, jomali wrote: > > Hi John, > > > I think your confusion lies in equating an .odb file with an Access > > database. The .odb file never contains the data. It is a sort of registry > > that points to wherever the data is. Thus, Base is the front end, a real > > database is the back end, and the .odb file serves as the intermediary > (to > > oversimplify). > > I agree with everything you have written, except that, by default, if > you use the wizard to create a "standard" (and I use that term very > loosely) ODB file, LO creates an ODB file which embeds its own > hsqldb-compatible data into the file and then uses the LO-shipped > hsqldb.jar to be the db engine. This is where it gets confusing for > people wanting to split out their data from their forms, queries, > reports, etc. > > Alex > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
