[Solved] Database crashes every time I open it

Discuss the database features
Locked
Shlomo47
Posts: 3
Joined: Mon Nov 25, 2024 9:55 pm

[Solved] Database crashes every time I open it

Post by Shlomo47 »

I am having the same issue as described by this user, but I don't know how to do the solution described here. Can anyone here help me?

viewtopic.php?t=111205
Last edited by MrProgrammer on Fri Dec 06, 2024 4:51 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved] Table definitions recovered; Table data was not recoverable; Topic locked so others with broken databases will create their own topics
OpenOffice 4.1.13 on Windows 11 Home
User avatar
Hagar Delest
Moderator
Posts: 33346
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: OpenOffice database crashes every time I try to open it

Post by Hagar Delest »

Hi and welcome to the forum!

I have split your post from the initial topic because it was solved: [Solved] OpenOffice database crashes every time I try to open it.
In that topic, the damaged file was provided by the OP and fixed by another user.
What have you tried already? What kind of file?
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
Shlomo47
Posts: 3
Joined: Mon Nov 25, 2024 9:55 pm

Re: OpenOffice database crashes every time I try to open it

Post by Shlomo47 »

The file is a .odb file. The issue described is the same as in the other topic: OpenOffice crashes whenever I try to view the Tables in OpenDatabase. I have so far just tried closing and re-opening the file.
OpenOffice 4.1.13 on Windows 11 Home
User avatar
MrProgrammer
Moderator
Posts: 5258
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: OpenOffice database crashes every time I try to open it

Post by MrProgrammer »

Shlomo47 wrote: Tue Nov 26, 2024 1:32 am OpenOffice crashes whenever I try to view the Tables in OpenDatabase.
You have the same symptom that hlb2 reported about a year ago. Whether you have the same underlying problem remains to be seen. In the earlier post hlb2 attached their ODB file to their topic so someone could examine it. A few hours later a forum volunteer give hlb2 a repaired file.

Now it is time for you to attach your ODB file to this topic the forum so someone can try to recover it for you. It seems unlikely that you will get your difficulty solved until you do that.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.5, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Shlomo47
Posts: 3
Joined: Mon Nov 25, 2024 9:55 pm

Re: OpenOffice database crashes every time I try to open it

Post by Shlomo47 »

Thank you! I'm attaching the file here so someone can recover it for me :)
OpenOffice 4.1.13 on Windows 11 Home
User avatar
Sliderule
Volunteer
Posts: 1290
Joined: Thu Nov 29, 2007 9:46 am

Re: OpenOffice database crashes every time I try to open it

Post by Sliderule »

Your database file, unfortunately, could NOT be recovered with data. That is, I am attaching a file, that contains your TABLE as you defined it, BUT it contains no records ( data ).

When I changed your file as a zip file, several of the internally defined database files ( both: data and backup ) were corrupt, and, could not be recovered. Therefore, I was only able to recreate the table definition.


I suspect, what might have happened, is your database file was open when either the computer crashed, of, perhaps a power outage, or, perhaps, a computer restart ( when Windows was updated ) . . . therefore . . . the internal files were not completely written to disk.

Any important file, of course, should always have a backup so you can recover the file, if needed. :super: :crazy: :bravo:

Sliderule
Locked