Hi Dave, Le 31/07/2014 21:22, dave boland a écrit : > All, > > Was reading the FAQ at https://wiki.openoffice.org/wiki/FAQ_%28Base%29 > and came upon some insight that worries me. Under the heading "So why > should I avoid 'embedded databases'?" it goes on to say the normal Base > file is not reliable, so use a split file, the points to Microsoft docs. > > My questions are: > 1. How robust are embedded Base files created by the GUI?
Not much, because when Base is running, the whole DB is in memory. Any crash (from any origin) may corrupt the DB and make it completely unreadable. A daily backup is necessary. > 2. If they are not that reliable, what is the LO Base procedure to > create a split database? > 3. Anything else I need to know? > Can you read French? I've written a document about just that. Title "How to get rid of the Base HSQLDB embedded mode". My sources were various wikis, forums and mailing lists messages (EN and FR) that I reviewed, rephrased and assembled. If anyone is interested in translating from FR, it's ok by me (there are 39 pages in all and there remains one or two draft paragraphs). The current license is CC-BY-SA. Feel free to contact me in PM. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: [email protected] 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
