[Solved] Database unable to open

Discuss the database features
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Database unable to open

Post by RoryOF »

As I understand it, to make hard drives appear faster, with the reduction in memory cost and the availability of low cost controllers, internal buffering has been built into hard drives. They remember the data sent to them, then sort it, so that it can be written in one movement of the heads across the disk platters. This makes modern hard drives much quieter - old codgers such as myself and several other Forum volunteers remember the constant "zip zip, click zip click" of older hard disks.

If the power goes off before these internal buffers in the drive have been written, that data is lost. So a good practice is to wait a few seconds for drives to finish their work after an "OK to power off message" from the operating system. That message has no knowledge of the internal buffering of the hard drives and the few extra seconds that one may wait is a lot less than the time taken to attempt to recover a damaged file/data, and ultimately to rebuild it.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
temotech
Posts: 3
Joined: Fri Apr 13, 2018 4:31 pm

Re: [Solved] Database unable to open

Post by temotech »

I need help . I have a odb database that i can't open anymore. do you any program that can fix it.
openoffice 4.1.1
temotech
Posts: 3
Joined: Fri Apr 13, 2018 4:31 pm

Re: [Solved] Database unable to open

Post by temotech »

I need help. My odb database is "out of service"!!!!!
openoffice 4.1.1
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

temotech wrote:I need help . I have a odb database that i can't open anymore. do you any program that can fix it.
Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire http://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule
temotech
Posts: 3
Joined: Fri Apr 13, 2018 4:31 pm

Re: [Solved] Database unable to open

Post by temotech »

this is the address: http://www.mediafire.com/file/291tl1ukz ... esktop.zip
Thanks for help Sliderule
openoffice 4.1.1
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

temotech:

I am sending you a PM ( Private Message ) regarding the status of you database.

Please read it and let me know how I should proceed.

Sliderule
ChrisS
Posts: 2
Joined: Thu May 03, 2018 9:35 am

Re: [Solved] Database unable to open

Post by ChrisS »

Good day,

I need urgent help please!

I've been working on my database for a couple of years now and have all our clients' information on this database. I did reporting on it yesterday (2018/05/02) and everything worked fine. I saved and exited like I always do. Then this morning when I wanted to open my database, it just doent open at all. First I thouht it might be an OpenOffice issue, but I can create a new database so it is not the program...

Does anyone have any advise on how I can resolve this problem?

Thank you,

Chris
OpenOffice3.3 / Windows 10 64-bit Operating System
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

ChrisS wrote:Good day,

I need urgent help please!

I've been working on my database for a couple of years now and have all our clients' information on this database. I did reporting on it yesterday (2018/05/02) and everything worked fine. I saved and exited like I always do. Then this morning when I wanted to open my database, it just doent open at all. First I thouht it might be an OpenOffice issue, but I can create a new database so it is not the program...

Does anyone have any advise on how I can resolve this problem?

Thank you,

Chris
Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire http://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

NOTE: OpenOffice Version 3.3 is a very old ( too old ) version. Additionally, since this is such an IMPORTANT / URGENT set of information, you should always have a backup of the file.

Sliderule
ChrisS
Posts: 2
Joined: Thu May 03, 2018 9:35 am

Re: [Solved] Database unable to open

Post by ChrisS »

Sliderule wrote:
ChrisS wrote:Good day,

I need urgent help please!

I've been working on my database for a couple of years now and have all our clients' information on this database. I did reporting on it yesterday (2018/05/02) and everything worked fine. I saved and exited like I always do. Then this morning when I wanted to open my database, it just doent open at all. First I thouht it might be an OpenOffice issue, but I can create a new database so it is not the program...

Does anyone have any advise on how I can resolve this problem?

Thank you,

Chris
Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire http://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

NOTE: OpenOffice Version 3.3 is a very old ( too old ) version. Additionally, since this is such an IMPORTANT / URGENT set of information, you should always have a backup of the file.

Sliderule
Hi,

Thank you for the reply. I've sent you a PM with the "MediaFire" link to the shared file.
OpenOffice3.3 / Windows 10 64-bit Operating System
Joe19
Posts: 2
Joined: Mon Sep 24, 2018 11:41 pm

Re: [Solved] Database unable to open

Post by Joe19 »

Hello, unfortunately I experienced the same problem. Once I opened the database, it gave a menu with different options for the file type. No matter which one I select, Open Office still doesn't recognize the format. I also installed the latest version and the problem persists. Can someone please send me directions on how to make it open, or it usually crashes in different ways and there is no general way to fix it?

Thanks a lot.

Joe

OpenOffice 4.1.5
OpenOffice 4.1.5 Windows 10
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

Joe19:

I am sending you a PM ( Private Message ) regarding the status of you database.

Please read it and let me know how I should proceed.

Sliderule
Joe19
Posts: 2
Joined: Mon Sep 24, 2018 11:41 pm

Re: [Solved] Database unable to open

Post by Joe19 »

Sliderule successfully fixed the database, and of course as every situation is different, it is difficult to provide general solution. Thank you very much!
OpenOffice 4.1.5 Windows 10
Smullie1
Posts: 2
Joined: Mon Oct 29, 2018 2:38 pm

Re: [Solved] Database unable to open

Post by Smullie1 »

Same problem here, hope you can help me too....
OpenOffice 4.1.5 on Windows 10 home
Smullie1
Posts: 2
Joined: Mon Oct 29, 2018 2:38 pm

Re: [Solved] Database unable to open

Post by Smullie1 »

Guess I'm up for a PM by Sliderule...Same problem here.

Thx in advance!
OpenOffice 4.1.5 on Windows 10 home
Krokodille238
Posts: 2
Joined: Sun Nov 11, 2018 11:22 am

Re: [Solved] Database unable to open

Post by Krokodille238 »

I might be the latest victim, of the database crash history in this forum. I have a database I'm been working on, for many years now, and suddenly it stop working. when I try to open it, I get the "Filter Selection" page. I would appreciate some help, to get it up running again.
OpenOffice 4.1.5 base, Ubuntu 17.10 OS 32 GNOME32
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

Krokodille238:

I am sending you a PM ( Private Message ) regarding the status of you database.

Please read it and let me know how I should proceed.

Sliderule
Krokodille238
Posts: 2
Joined: Sun Nov 11, 2018 11:22 am

Re: [Solved] Database unable to open

Post by Krokodille238 »

Thanks Sliderule. My database is fully recovered and working again (thats nearly 30 years of work you saved), so again many thanks for your help.

Krokodille238
OpenOffice 4.1.5 base, Ubuntu 17.10 OS 32 GNOME32
michaelboix
Posts: 1
Joined: Thu Jan 31, 2019 11:59 am

Re: [Solved] Database unable to open

Post by michaelboix »

Hi,
i also need help with an .odb file,
you may can help me?

Kind regards
Michael
Open Office 4.1.6.
Windows 10
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

michaelboix:

I am sending you a PM ( Private Message ) regarding the status of you database.

Please read it and let me know how I should proceed.

Sliderule
sandfork4@gmail.com
Posts: 6
Joined: Sat Mar 09, 2019 5:27 pm

Re: [Solved] Database unable to open

Post by sandfork4@gmail.com »

unable to open db same problem need the fix.
OPenoffice 4.1.5 Windows 10
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

sandfork4 @ gmail.com:

I am sending you a PM ( Private Message ) regarding the status of your database.

Please read it and let me know how I should proceed.

Sliderule
sandfork4@gmail.com
Posts: 6
Joined: Sat Mar 09, 2019 5:27 pm

Re: [Solved] Database unable to open

Post by sandfork4@gmail.com »

Problem fixed
OPenoffice 4.1.5 Windows 10
eugenefairfield
Posts: 1
Joined: Tue Jun 23, 2020 5:57 pm

Re: [Solved] Database unable to open

Post by eugenefairfield »

I have this same problem. Trying to open a database I originally set up under Windows 7, but have accessed recently under Windows 10. Now says "driver class '' could not be loaded." Lot's of important information is inaccessible, please help.
OpenOffice 4.2.7 on Windows 10 v 1909
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Database unable to open

Post by RoryOF »

It is helpful if we are told the name of the underlying database engine.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Database unable to open

Post by Villeroy »

Image
Does the status bar look like this?

---------------------------
Image
Did you install a 32-bit version of Java? Notice the C:\Program Files (x86)\ in the path.

You get it from here:
Image

You can also install LibreOffice instead of OpenOffice. LibreOffice for WIndows is 64-bit software and works well with a 64-bit Java
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
TacoNinja
Posts: 1
Joined: Sun Mar 20, 2022 10:18 pm

Re: [Solved] Database unable to open

Post by TacoNinja »

Same issue. Please Sliderule.
Open Office 4.1.11
macOS and Windows
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

TacoNinja:

I am sending you a PM ( Private Message ) regarding the status of your database.

Please read it and let me know how I should proceed.

Sliderule
TimB
Posts: 1
Joined: Tue Apr 25, 2023 9:41 pm

Re: [Solved] Database unable to open

Post by TimB »

I'm getting a filter selection box when I try to open my OpenOffice database. Can you help, Sliderule?
Attachments
FilterSelectionMessage OpenOfficeDatabaseProblem.JPG
FilterSelectionMessage OpenOfficeDatabaseProblem.JPG (53.23 KiB) Viewed 4022 times
OpenOffice 4.1.2 on Windows 11
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Post by Sliderule »

TimB:

I am sending you a PM ( Private Message ) regarding the status of your database.

Please read it and let me know how I should proceed.

Sliderule
Post Reply