I have an odb file which was created in LO 7.3 and has nearly 9000 records. When I open the same odb file in LO 25.2, almost the last 200 records are missing! How can that happen when it is the same odb file, and is there an easy way to fix it.
Thanks
Is it an embedded database?
Any filters set? (Had once a problem with one table until I realized a filter I set was saved and still active.)
If you open the file again with 7.x , can you see the missing data?
.
Type of your database? Firebrid/hsqldb/dbase … ?
.
PS: check for backups and copy old versions to a safe place, before poking around…
No, it is just a fairly simple database and does have 1 filter table. When I open the file in LO 7.3 yes the missing data i there. That is how I know about it missing in LO25.1
It is an embedded HSQLB database when open inLO25.1
Tested with LO 25.2.0.3 and also 24.8.4.2: Same database file, both will show all 8187 rows of the table of HSQLDB example database here.
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
I don’t doubt what you say, but with LO7.3 I have 8910 records and with LO25.1 it only shows 8725 records. I cannot understand why the difference when it is the same file.
One other difference I have found is that in the table of LO25.1, record number 8724 is for 15/09/2024, then record 8725 jumps to 21/12/2024