I’m using LibreOffice 6.2 Base on mac OSX Catalina (10.15.7).
I have a simple database with 4 main entities and some relationship.
When I try to access to tables from Base main window I receive the error message: “The connection to the data source … could not be established - firedird_sdbc error: *violation of PRIMARY or UNIQUE KEY constraint…”
I suppose the database file is corrupted… but I can’t see the table any more to do any recovery action…
Is there a way to recover it or fix the error?
Is there a way to open the database disabling integrity constraints checking? (to delete corrupted data)
Thanks in advance for help.
I already tried -with no effect- to:
- Open Base in Safe mode
- Copy the .odb file
- Write direct SQL commands