https://bugs.documentfoundation.org/show_bug.cgi?id=160715
--- Comment #10 from Chris Good <[email protected]> --- Hi Robert, I am very careful to save any changes to forms/macros/tables, then also save the database, very regularly. Thanks for you comment about using a macro to save the file automatically. I hadn't really thought about that much yet. I do often save, close, then manually copy the .odb to a cloud backed up folder, then date and time stamp the filename. I have found some good info in https://ask.libreoffice.org/t/is-there-a-way-to-automatically-save-a-database/46905) which also refers to https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook (Chapter 9 Macros → Securing you database) I have recently changed from an embedded database to an external HSQL 1.8 DB using Villeroy's Python macro (https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=86071), because I need to separate the data from the code so I can provide support for my system to some-one else. I decided to stay with external HSQLDB 1.8 for the moment instead of go to FireBird because of the problems with dates and also becuase Firebird does not support SPACE() which I use to simulate multi column comboboxes. I shall ponder further. I will probably end up modifying my java backup utility (https://github.com/goodvibes2/BackupGnuCashWin) which automates backing up multiple files to an encrypted datetime stamped file in a cloud folder using 7-Zip, to also handle my Base app. I'm also going to turn on Tools,Options,Load/Save - General, "Mark Save AutoRecovery information every 10 minutes" but I guess this won't help with this date format problem which presumably will be fixed now that my data is in an external database. -- You are receiving this mail because: You are the assignee for the bug.
