[Solved] Database unable to open

Discuss the database features

[Solved] Database unable to open

Postby Karena » Mon Jul 14, 2014 3:27 pm

Hi,

I've been working for the last few weeks on an ODB file. I saved (yes!) and went to open something else and Open Office crashed. I tried to reopen the file and I got a "Filter Selection" window.

I don't know what happened! Is there anything I can do to try to fix it?? I've tried the zip trick and creating a new user profile, and it's still not working.

Thank you so much! I really appreciate the help, it's a very important file.
Last edited by Karena on Mon Jul 14, 2014 4:56 pm, edited 1 time in total.
Open Office 4.1.0 | Windows 7
Karena
 
Posts: 1
Joined: Tue Jul 08, 2014 7:44 pm

Re: Database unable to open and asking for "Filter Selection

Postby Sliderule » Mon Jul 14, 2014 3:47 pm

I just sent you a PM ( Private Message ).

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby Pastor Bob » Wed Jul 16, 2014 9:07 pm

I have this same problem on my .odb file. Worked fine for a year. Now I get that Filter Selection window. Solution? Many thanks!
OpenOffice 4.0.1 on Windows Vista on Dell Inspiron 1525
Pastor Bob
 
Posts: 9
Joined: Wed Jul 16, 2014 8:30 pm

Re: [Solved] Database unable to open

Postby Sliderule » Wed Jul 16, 2014 10:25 pm

Pastor Bob:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby Pastor Bob » Thu Jul 17, 2014 5:00 pm

Thanks Sliderule! You fixed my corrupted .odb file! I set the backup function to help prevent this. Unfortunately, I had been using my dropbox account as a backup, and it just saved my corrupt file with the same name, and was no use as a backup. I know better now.
OpenOffice 4.0.1 on Windows Vista on Dell Inspiron 1525
Pastor Bob
 
Posts: 9
Joined: Wed Jul 16, 2014 8:30 pm

Re: [Solved] Database unable to open

Postby OPE1rginla » Tue Jan 06, 2015 7:49 pm

I am having the same problem. Can anyone help? Pastor Bob or Sliderule? Thanks,
OpenOffice 4.1.1 on MacOS X
OPE1rginla
 
Posts: 1
Joined: Tue Jan 06, 2015 7:42 pm

Re: [Solved] Database unable to open

Postby Sliderule » Tue Jan 06, 2015 8:25 pm

OPE1rginla:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby macstibs » Thu Jan 15, 2015 11:06 pm

Same problem here.

Accessed an ODB that I saved to Dropbox using OpenOfficeAndroid and then got a corrupt DB error back on the desktop.

Tried to copy the data over to a new ODB and then rezip but I'm getting the Filter screen instead of it opening properly.

Thanks.
OpenOffice 4.1.1 on MacOS 10.10
macstibs
 
Posts: 1
Joined: Thu Jan 15, 2015 11:03 pm

Re: [Solved] Database unable to open

Postby Sliderule » Thu Jan 15, 2015 11:56 pm

macstibs wrote:Same problem here.

Accessed an ODB that I saved to Dropbox using OpenOfficeAndroid and then got a corrupt DB error back on the desktop.

Tried to copy the data over to a new ODB and then rezip but I'm getting the Filter screen instead of it opening properly.

Thanks.

I will momentarily send you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby JJJoseph » Sat Jan 17, 2015 9:51 am

Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.
OOo 3.4.X on MS Windows 7 + Blackberry 10
JJJoseph
 
Posts: 173
Joined: Thu Dec 13, 2007 2:55 am
Location: Vancouver, Canada

Re: [Solved] Database unable to open

Postby DACM » Sat Jan 17, 2015 1:34 pm

JJJoseph wrote:Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.

JJJoseph,

Please be respectful of Sliderule's skills and dedication involved with .odb file repair. The steps are often beyond a simple tutorial. The process requires advanced ZIP archive repair tools, significant knowledge and experience with .odb file specifications (such as embedded query, form, report and database-file storage), expertise with HSQLDB configurations and recovery mechanisms, as well as, tedious manual HSQL 'script' file repair on a case-by-case basis. The results must then be repackaged and tested. Private Messaging is likely used to eliminate the possibility that a desperate user might unwittingly post confidential database data in a public forum. Lets just tip our hats to Sliderule for this invaluable service and dedication to the Base user-community.

We can generally avoid the need for .odb file recovery by storing our files in a cloud-sync'ed folder featuring file-versioning services (Dropbox, Google Drive, etc.).

I should also mention:
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: [Solved] Database unable to open

Postby Sliderule » Sat Jan 17, 2015 5:47 pm

JJJoseph wrote:Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.

I send a private message, to inform the user of MY REQUIREMENTS, if I am to help a user. If/when the user meets those requirements, I will attempt to repair the file. Sometimes, a user elects not to reply or even acknowledge or read the PM.

No, it is NOT a list of things to do to repair a corrupt .odb file, since what must be done, or even, if it can be done ( repaired ), depends on the 'condition/contents' of the individual file. Some of the tools are also, operating system specific.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby JJJoseph » Sun Jan 18, 2015 9:30 am

Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.
OOo 3.4.X on MS Windows 7 + Blackberry 10
JJJoseph
 
Posts: 173
Joined: Thu Dec 13, 2007 2:55 am
Location: Vancouver, Canada

Re: [Solved] Database unable to open

Postby Sliderule » Sun Jan 18, 2015 5:27 pm

JJJoseph wrote:
Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.

JJJoseph:

Thank you for telling me what I should or not do.

I have now learned, you are expert in "bad manners".

To the over 75 users, over the years, where, I was able to 'recover' a Base file ( *.odb ) . . . I apologise . . . per user JJJoseph . . for wasting forum bandwidth with one private message.

Thank you very much in teaching me something today.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby jimmpa25 » Fri Jan 30, 2015 7:16 am

Can i please have some help with this to, when i try to open my work i get the filter selection window and i cant choose anything there, please help :)
OpenOffice v4.11
Win 7
jimmpa25
 
Posts: 1
Joined: Fri Jan 30, 2015 7:13 am

Re: [Solved] Database unable to open

Postby Sliderule » Fri Jan 30, 2015 5:46 pm

jimmpa25:

Welcome to the OpenOffice / LibreOffice Base forum.

You said, wrote:

jimmpa25 wrote:Can i please have some help with this to, when i try to open my work i get the filter selection window and i cant choose anything there, please help :)

While I would like to help you . . . user JJJoseph has written:

JJJoseph wrote:
Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.

Since, the forum moderators have not added anything to this forum post . . . I have learned that . . . no . . . I cannot help users with corrupt Base files.

However, I am confident . . . user . . . JJJoseph . . . will help you repair your file, and, do it without "wasting everybody's time & space" and with "good manners". :)

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby F3K Total » Fri Jan 30, 2015 6:42 pm

Hello,
IMPOV, everybody can help the way he/she likes.
I am able to repair broken databases, just by reading previous posts of Sliderule (thank you so much) and others here in the Forum.
So JJJoseph :evil: is just too lazy to search and learn it, all necessary informations are available.
He's the one, wasting everybody's time & space with his unfriendly comments and unnecessary discussions.
Sliderule, don't let him bother you!
R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 895
Joined: Fri Dec 16, 2011 8:20 pm

Re: [Solved] Database unable to open

Postby Sliderule » Fri Jan 30, 2015 6:49 pm

F3K Total wrote:Hello,
IMPOV, everybody can help the way he/she likes.
I am able to repair broken databases, just by reading previous posts of Sliderule (thank you so much) and others here in the Forum.
So JJJoseph :evil: is just too lazy to search and learn it, all necessary informations are available.
He's the one, wasting everybody's time & space with his unfriendly comments and unnecessary discussions.
Sliderule, don't let him bother you!
R

F3K Total:

I am certainly not letting user JJJoseph "bother me". The exact opposite . . . as I have posted above . . . I have learned from user JJJoseph . I am just, following the wise recommendations posted by said user. :super:

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby acknak » Wed Feb 18, 2015 3:02 am

May I state clearly, for the record, that there is no forum policy against using PMs to help users privately. Volunteers offer their valuable expertise here pro bono and each is entitled to choose the approach that they feel is most appropriate.

While we encourage people to resolve issues publicly so others can benefit from the discussion, there is no forum policy regarding this and it is not, from the standpoint of the community forum, considered improper in any way for someone to choose to use a private channel. Sliderule has done nothing improper in using the private channel to resolve the problem.

If you dislike using a private channel, that is your choice, clearly. But we ask everyone to respect each other's choices and refrain from making personal character attacks.

A personal note: I sometimes help with damaged document files (Base problems are beyond my skills) and I've considered trying to write down the steps: aside from some general strategies (which are already written down, and apply to Base documents as well), there is no recipe for recovering a damaged file. Every one is a little different and it often takes some knowledge of xml and a bit of intuition to fix the problem. Writing that down for someone else to follow would end up as a book. About half the time, I end up using a private channel to solve the problem.

Any comment or discussion on this issue should be made on the Site Feedback area of the forum: https://forum.openoffice.org/en/forum/v ... m.php?f=50
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: [Solved] Database unable to open

Postby lennonenglish » Wed Apr 01, 2015 3:32 pm

i'm having thesame problem. can someone please post the solution? thanks!
OpenOffice4.1 on Win 7
lennonenglish
 
Posts: 1
Joined: Wed Apr 01, 2015 3:26 pm

Re: [Solved] Database unable to open

Postby Sliderule » Wed Apr 01, 2015 4:06 pm

lennonenglish:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby jslcpd157 » Thu Apr 30, 2015 6:20 pm

I am having this same issue. I am working on OpenOffice 4.1.1, on Windows 7.
OpenOffice 4.1 on Windows 7
jslcpd157
 
Posts: 2
Joined: Thu Apr 30, 2015 6:18 pm

Re: [Solved] Database unable to open

Postby Sliderule » Thu Apr 30, 2015 7:48 pm

jslcpd157:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby thatchristianguy » Fri May 01, 2015 5:37 pm

I am getting a corrupt .odb file that I was in several minutes ago. Is there a solution I can pointed to? Thank you for you help with this.
OpenOffice 4, Windows 7
thatchristianguy
 
Posts: 2
Joined: Fri May 01, 2015 5:36 pm

Re: [Solved] Database unable to open

Postby F3K Total » Fri May 01, 2015 6:21 pm

How do you see, that it's corrupt?
R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 895
Joined: Fri Dec 16, 2011 8:20 pm

Re: [Solved] Database unable to open

Postby thatchristianguy » Fri May 01, 2015 7:24 pm

When I go to open the .odb the FIlter Selection window opens and there is no option that will allow the database to open regularly.
OpenOffice 4, Windows 7
thatchristianguy
 
Posts: 2
Joined: Fri May 01, 2015 5:36 pm

Re: [Solved] Database unable to open

Postby Villeroy » Fri May 01, 2015 8:27 pm

thatchristianguy wrote:When I go to open the .odb the FIlter Selection window opens and there is no option that will allow the database to open regularly.

... and you are running Windws without any backup facility so you do not have any working version of that file?
Well, that database might be lost.
[Tutorial] Avoiding data loss with built in HSQLDB
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25384
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Database unable to open

Postby deadline13 » Thu May 07, 2015 11:44 am

Please help. My database crashed a while ago and cant be opened. Same issue.
Please help I need the database back. Been working on it for quite a while :crazy:
OpenOffice 4.1.1 on MacOS 10.10.3
deadline13
 
Posts: 21
Joined: Thu May 07, 2015 11:32 am

Re: [Solved] Database unable to open

Postby Sliderule » Thu May 07, 2015 3:07 pm

deadline13:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby jtbernier » Tue Jul 07, 2015 1:13 pm

Same issue... hoping for a PM from Sliderule
OpenOffice 4.1.1 on Windows Vista
jtbernier
 
Posts: 1
Joined: Tue Jul 07, 2015 1:10 pm

Next

Return to Base

Who is online

Users browsing this forum: No registered users and 13 guests