Re: [libreoffice-users] Min. skills for Base
Hi Robert Thank you very much for this useful information! Regards Hanspeter On 01.01.24 12:58, Robert Großkopf wrote: Hi *, stability is a problem for all internal databases. You could test this by input some data, save this data and kill the LO-process. No data had been saved when database has been opened next time. Better: Move the internal database out of the *.odb-file. I'm using LOBase as backend for Firebird-database files if I create standalone-database solutions. Data were saved independent of a crash from LO. Best for solutions for groups (more than one user at the same time): MariaDB or PostgreSQL. Both could be connected by an internal driver supported by LO. Could also be connected to both by JDBC or ODBC. More informations could be found at https://documentation.libreoffice.org/en/english-documentation/ (Base Guide) Base Guide is a translation of German Base Handbuch, which conatins much more information at this time. See my homepage. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Min. skills for Base
Hello, I work with Base (stand alone) as well since many years, the main application with it has several thousand records. However my experience is that base is less stable compared to e.g. LO Calc or LO Writer. My most critical app is still in ACCESS and I will change that to MariaDB. As like for any other application the rule of doing a backup is simple: Do the backup before the amount of data entry/edit you don't want to do again. I have an app on an external drive and use the internal drive as backup drive by using 'Save As...' and use the following file name convention, e.g. for today it would be: MXDB_2024-0101A.odb MXDB_2024-0101B.odb for tomorrow: MXDB_2024-0102A.odb MXDB_2024-0102B.odb etc. Happy hew year to all! Hanspeter On 01.01.24 00:12, Harvey Nimmo wrote: Don't give up...Base is a powerful tool for managing all kinds of data. and Robert Großkopf is an excellent advisor! Happy new year to all! Harvey On Sun, 2023-12-31 at 13:43 -0500, Jonathan Ames wrote: In trying to reopen table I'd created, I cannot add records -- says ERROR "Attempt to insert null into a non-nullable column: column: Key table: Owntunes in statement [INSERT INTO "Owntunes" ( "Pubdomain?","Song") VALUES ( ?,?)]--" anyway I don't know what it means. The table is "Owntunes. All I did was try to begin a new record.I also get a very small red icon containing an "I" with a slash through it, near top left of "open database". Manual "Base" section doesn't cover this. Using MAC OS Sonoma. Have Java on computer. Wondering if I will really have to learn to code if I want sort of consumer database formerly available (e.g., Lotus Approach) -- I'm 77. New to LibreOffice: is understanding and responding to such as above required for use? Sort of like the following learning curve: 1. - Databases store and manipulate data. 2. - Data can be numeric or verbal. 3. - E = MC2 Do other folks give up on LibreOffice Base as too technical? Any idea where they end up? Thanks Jonathan Jonathan Ames, PhD Clinical Psychologist 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: can't find the JRE with LibreOffice 6.2
Ken, Have this problem sometimes as well (even in 5.1.6.2, have to use this version because of this version of the mail merge function) it seems to be a file locking problem: When having a spreadsheet open, then trying to open a merge document that accesses to an LO Base address query as data spirce I get the 'can't find the JRE...' error. workaround: close all files, exit LO open LO Base address query try to edit the query (here would apear the JRE error message) [save, if edited] close query save query (important, to write the modifications to the files) [close LO Base] load merge document (LO Writer) Tools / Options / LibreOffice / Advanced / Activate 'Use a Java runtime environment' after a few seconds the JRE entry apears OK and everything works fine Hanspeter Am 23.12.2019 um 11:48 schrieb Alexander Thurgood: Le 20/12/2019 à 21:16, Ken Brucker a écrit : Ken, If you downloaded your JRE with Internet Explorer, it might have downloaded the 32bit version because some versions of IE are 32bit even on W10 (don't ask me why, I don't know). Clearly a 32bit version of JRE won't work with 64bit LO. To be honest, I don't recommend downloading just the JRE - I would rather suggest you get a current 64bit Java JDK instead, unzip that to a path/directory to which LO has read/write permissions, and then retry the Java environment recognition setup from within LO. Just my 2c. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy