I have updated to the latest version after my problem started. Basically, I can open the database. I can open my reports and/or print the reports and the same for the queries. When I try to open the table containing all my information the program freezes and will not respond. After trying some fixes on the internet with no success, I am here for possibly more help. I tried the zip file suggestion on the internet, it didn’t work for me, I couldn’t open the newly created file, It doesn’t make sense to me that I can run all the queries and reports, but cannot get into the data table to do any editing. When I click on the tables, it just sits there and stares at me and eventually just freezes up. Then when I close out of everything, reboot and try to open it again, of course the program wants to fix the database, but I still have the same issue again. Any new ideas would be appreciated. Thank you
You are using internal database HSQLDB? When queries and reports work you get contact to the database without any problem. Your queries ask for content of the specific table, which runs into an error when trying to open directly?
Might be there is a special problem by setting a filter or a sorting order by the GUI of the tables. It would be good to see the content of content.xml inside the database file.
I am not sure what you are asking of me here. Everything worked just fine until about 2 months ago,. I had a computer that had a hard drive failing, I thought that might be the problem. I purchased a new computer and still have the same problem. I can send you the data file, if that is what you are asking
Same issue here, I think, and as in this topic. I’m migrating from MS Office 2017 to LO 25.2.4.3 (X86_64) on Windows 11 Pro (24H2) with JRE 1.8.0_451 (x86_64, registered), so both are 64 bit. Calc, Write, and Impress work fine but Base hangs almost immediately after I try and create any table. Any input would be much appreciated!
All odf-files are zip-files. Copy your .odb-file and rename to .odb.zip
Thus file you can usually open directly by double-click to see the contents. Search for a file named contents.xml
No on first sight you don’t have the same issue, because @andreatk can use queries and reports while the thread linked by you can not.
Good point! I should’ve read more carefully. I’ve copied my reply to the thread I linked to. Sorry for the inconvenience!
We have “solved” the problem per private mail:
Database file could be opened and worked well here on OpenSUSE Linux. Seems to be a special Windows problem. So I set experimental features on, reopened the file and migrated it to internal Firebird. This Firebird file worked well on Windows.
Hint: The migration wizard will set db:parameter-name-substitution="false"
. So you couldn’t create forms with subforms. Must be changed to true
in content.xml. Could only be changed by this procedure, started from Base file:
SUB FB_Parameter
DIM oSettings AS OBJECT
oSettings = ThisComponent.DataSource.Settings
oSettings.ParameterNameSubstitution = True
END SUB
Thanks for your help here and in the other thread. I used the latter to solve my problem. I think I prefer to use Firebird as an external database.