[Solved] Opening BASE database

Discuss the database features

[Solved] Opening BASE database

Postby tomlock2 » Thu Dec 06, 2018 5:45 pm

I create an OO Database, create 1 small table in it and save it. I cannot reopen it. Always comes up with a FILTER SELECTION window when I try. This happened using OO 4.1.5 and i just updated to 4.1.6-- same thing. I cannot create, save and reopen ANY OO Base file. Any suggestions?
Last edited by Hagar Delest on Fri Dec 07, 2018 11:03 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.5
OS Windows 10
tomlock2
 
Posts: 3
Joined: Thu Dec 06, 2018 4:17 am

Re: Opening BASE database

Postby John_Ha » Thu Dec 06, 2018 8:20 pm

It sounds like a corrupted file.

Please upload the file so that it can be analysed. Use the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.

Create a new test file. Does it work OK?
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5980
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Opening BASE database

Postby tomlock2 » Fri Dec 07, 2018 12:11 am

I could send you the file but it maybe a waste of time since problem occurs with any OO Base file I create. The problem is not just 1 OOBase file it is ALL OO Base files that I create.
Open Office 4.1.5
OS Windows 10
tomlock2
 
Posts: 3
Joined: Thu Dec 06, 2018 4:17 am

Re: Opening BASE database

Postby Villeroy » Fri Dec 07, 2018 12:19 am

Can you open and re-open other people's databases from viewforum.php?f=100 ?
download/file.php?id=11250 is an embedded HSQLDB without macros. Should work with any default setup of OpenOffice and LibreOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25952
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Opening BASE database

Postby robleyd » Fri Dec 07, 2018 1:42 am

May also be relevant - where are you saving the file(s)? Default location on C: - other location on C: - external device, type?
Cheers
David
Apache OpenOffice 4.1.6 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2241
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Opening BASE database

Postby John_Ha » Fri Dec 07, 2018 2:00 am

tomlock2 wrote: I cannot reopen it. Always comes up with a FILTER SELECTION window when I try.

An AOO database .odb file is a binary ZIP file.

If you see the ASCII Filter Options pop-up below when opening a .odb file it is because the .odb file is not a binary ZIP file and is not a proper .odb file. It is a flat ASCII file like a .txt file.
Attachments
Clipboard01.png
ASCII Filter pop-up when opening a flat ASCII file.
Clipboard01.png (10.73 KiB) Viewed 114 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5980
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Opening BASE database

Postby tomlock2 » Fri Dec 07, 2018 3:11 am

Robleyd === you nailed it!

I was saving all of my newly created BASE files on a Flash Drive attached to my router. If instead I save them on my C: drive everything works!
Can someone explain why that is the case??
Open Office 4.1.5
OS Windows 10
tomlock2
 
Posts: 3
Joined: Thu Dec 06, 2018 4:17 am

Re: [Solved] Opening BASE database

Postby Villeroy » Sat Dec 08, 2018 4:17 pm

If the status bar of your "Base database" looks like this:
Image
then you should know that this is a database package which installs a HSQL database to a temporary directory when you start editing data and which gets repackackaged when you stop editing data.

While being very brittle, this database container is good enough for educational purposes and for less important stuff. In any case you must not use this database without backups and you definitively must not store it on a flash drive (well, you may store backups on flash but not the working copy).

viewtopic.php?f=83&t=17125&p=459391#p459391
Using a USB stick with OpenOffice.org and its Derivatives
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25952
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests