I have a complex form with lots of data behind it in multiple tables with queries and reports.
I made a few minor changes to the form today and successfully saved the changes.
When I went to close Librebase it would not respond and asked if I wanted to save.
I tried multiple times to do a save, so finally to close Librebase I chose not to save.
When I launched Librebase again I got the window with the icons/buttons to access my form and previous reports I had generated.
When I clicked on my main form I get a blank screen to create a new form.
HELP! Is there a way to recover by work and data?
Thanks
Have a look in “Tables” pane. Any tables there in Base?
Which database do you use? Internal HSQLDB?
Robert,
Thanks for getting back with me so fast.
Everything is gone.
I checked the file size of the .odb file and it says zero KB.
I am using HSQLDB.
Do you know if this has occurred to others?
Thanks
I was able to restore the .odb from a backup yesterday and redo the form and table data changes.
Thanks again for the advice - I was freaking out. It looks like the tables, queries, forms and reports are all stored in the .odb file?
If you are using internal databases (HSQLDB, Firebird) all data will be saved inside the *.odb-file. Queries and reports are always part of the *.odb-file. Forms coulöd be used as forms inside the *.odb-file or external forms, which are Writer documents.
.
Internal databases are a good choice for developing and learning to work with Base. But ther data aren’t very save inside the *.odb-file, because the data will be unzipped when opening the Base file and will be zipped when closing the Base file. I have created a macro so save my *.odb-files every time I open the *.odb-file.
.
Better use external databases (if only one user will connect) or server databases (for more than one user at the same time. Internal databases could be changed to external databases and also could be changed to server databases.