Program crashed and I lost my tables

Discuss the database features

Program crashed and I lost my tables

Postby mariana98 » Fri Feb 23, 2018 3:06 am

I was working on a table in Base and the system crashed. It erased the tables even though the information was already saved (at least 80%). Instead I am left with a file .odb. lck Can someone help me recover the information?
Open Office 4.1.5
mariana98
 
Posts: 1
Joined: Fri Feb 23, 2018 2:59 am

Re: Program crashed and I lost my tables

Postby UnklDonald418 » Sat Feb 24, 2018 7:27 am

Before doing anything make a backup of your .obd file.
Open any OO module and select Tools->Options->Open Office->Paths. Look on the list to find the Backups folder and note the path to that folder. With a file browser navigate to that folder and little luck there will be a usable backup stored there.
If you find nothing there then you could try the recommendations found at
Recovering a damaged odb file
Report back whether you were successful or not.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 807
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Program crashed and I lost my tables

Postby the_watchmann » Tue Feb 27, 2018 10:59 am

It's an age old Base bug that annoyingly won't go away. I learned the hard way not to trust in the HSQL database of Base. Instead, why not create a sqlite3 database with all your tables etc, then via ODBC link base to it. I have had no crashes/ losses for at least three years now since going over to sqlite3. Just install sqliteodbc (windows or linux). https://crcok.wordpress.com/2014/10/24/ ... ffice-org/
https://www.openoffice.org/documentatio ... SQLite.pdf
OpenOffice 4 Linux Mint 17.2
User avatar
the_watchmann
 
Posts: 18
Joined: Wed Oct 05, 2011 2:40 pm

Re: Program crashed and I lost my tables

Postby RoryOF » Tue Feb 27, 2018 11:11 am

mariana98 wrote:I was working on a table in Base and the system crashed. It erased the tables even though the information was already saved (at least 80%). Instead I am left with a file .odb. lck Can someone help me recover the information?


The lock file contains no useful information - it is merely a housekeeping file to prevent multiple access to the main file in circumstances that a user has several copies of the file open and gets confused which copy is being edited, or in a business situation to permit only the first user to make changes to the file.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26716
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Program crashed and I lost my tables

Postby UnklDonald418 » Tue Feb 27, 2018 5:18 pm

The problem isn't with HSQL as the_watchmann suggests. The problem is with the default Embedded database model used by Base. Any type of connection that stores the data outside of the .obd zip file solves the problem.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 807
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests