Having set up a Libre Base file using HSQL I had issues with the odb becoming corrupted when 2 users opened it and worked on it.
I transported the Database to Firebird (internal). The same issue persisted. I have tried clearing the Libre Office Profile. No Luck.
The odb file when viewd in 7zip shows corrupt: Content.xml, content_before_migration.xml,settings.xml and …\database* all files.
When working stand-alone the application and the data are maintained. I noticed that in making an update (adding rows in a table) on one machine that the same data is not loaded on the other machine (refreshed by opening and closing a form).
Any ideas on how to remedy this.
Both internal databases are databases for only one user on a local system. You could create external databases from the internal databases, but you will need a HSQLDB server or a Firebird server to connect with more than 1 user at the same time.
.
If you open a internal database it will write all content into memory of the local user (HSQLDB) or will write the firebird.fbk to the temporary folder and extract this file to firebird.fdb. So different users will be working with different data sources on there own system. When writing back data (when closing the connection, closing the *.odb-file …) the old data will be replaced. It shouldn’t be possible to get a write access for a second user, but seems you got a workaround to exactly do this, which only produces chaos.