After working at a new club membership database for a week or so. Now when trying to open the table I get a dialogue box saying: The connection to the data source "<database name>" could not be established. The driver class '' could not be opened.
Could someone please show me how to recover this?
Using Agent Ransack to find all of my *.odb files I found a large number of backup files, apparently produced every few seconds.
They were in a directory ...\AppData\Roaming\OpenOffice\4\user\backup and with numbered filenames like fname.odb_978.odb
I took the highest numbered one and renamed that file to just fname.obd and hey-presto recovered my data table and queries.
[Solved] Lost database table and queries
[Solved] Lost database table and queries
Last edited by ESgt on Wed Mar 27, 2019 4:31 pm, edited 1 time in total.
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
Re: Lost database table and queries
It might be that Java has been updated recently on your system. Go to Extra -> Options -> OpenOffice -> Java and select a Java version. Note that you have to use a 32-bit Java version.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
Re: Lost database table and queries
When you select a version in the options dialog, you see the path of the selected version below the list. If the path starts with "C:\Program Files (x86)\" the Java version is compatible. Any path with "C:\Program Files\" indicates a 64-bit Java which is incompatible with OpenOffice unless your whole Windows system runs on 32 bit.
See Troubleshooting Open/LibreOffice and Java
See Troubleshooting Open/LibreOffice and 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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Lost database table and queries
Quick test on the file:
Change the file name extension to .zip instead of .odb. OpenOffice documents are zip archives actually.
If you can open the renamed archive with a zip tool it is rather unlikely that the file is damaged.
Change the file name extension to .zip instead of .odb. OpenOffice documents are zip archives actually.
If you can open the renamed archive with a zip tool it is rather unlikely that the file is damaged.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Lost database table and queries
I cannot tell what you mean by 'Go to Extra ->...eremmel wrote:It might be that Java has been updated recently on your system. Go to Extra -> Options -> OpenOffice -> Java and select a Java version. Note that you have to use a 32-bit Java version.
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
Re: Lost database table and queries
Translation problem: try /Tools /Options/ OpenOffice /Java
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Lost database table and queries
OK, found there: Location: C:\Program Files (x86)\Java\jre1.8.0_191 and see that there is a button for Class Path. With that I set the folder name. But there is no improvement after restating.RoryOF wrote:Translation problem: try /Tools /Options/ OpenOffice /Java
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
Re: Lost database table and queries
OK, made a .zip file copy and opened with WinRAR giving a list of 6 folders and 3 files:Villeroy wrote:Quick test on the file:
Change the file name extension to .zip instead of .odb. OpenOffice documents are zip archives actually.
If you can open the renamed archive with a zip tool it is rather unlikely that the file is damaged.
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
Re: Lost database table and queries
Troubleshooting Open/LibreOffice and Java
Ignore the class path button. That setting is not relevant for your embedded database.
The zip content looks OK.
Ignore the class path button. That setting is not relevant for your embedded database.
The zip content looks OK.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice