Interesting to know!
For my part, by precaution, all my data are kept in separate dbf tables,
linked to an odb file.
Why do I use dbf? Standard format making it portable to all softs,
notably GIS softwares. Old archives can also be read even if you changed
your soft.
There is not much information on long term use of databases, let's say
more than 10 years (e.g.: keeping adresses or bibliographic data).
The file can get corrupt. But worser, some data inside the file can get
corrupt, without changing the structure of the dbf file,and you just
notice it when you query these data.
I heard once that MS-access is not stable enough in long term use. And,
sometimes, odb file can get problems (for ex. shutdown of windows while
some forms are open in the odb file).
But, when the tables are kept in separate files, recovery is easy, using
a backup copy of the odb file.
Using LibreOffice 3.3.2 on windows Vista.
NB: I came to openoffice several years ago mainly because of its good
integration with databases (standalone use).
I wonder if my way of using Base is optimal, trying to find the way
among the many possibilities offered by Base and Calc.
Many thanks to the developers,
Paul
Le 17/03/2012 11:58, Andreas Säger a écrit :
Am 17.03.2012 11:41, Ian Whitfield wrote:
What "filter" must I selct or what must I do to get my Database going
again??
You need to restore your database from a backup. It is lost. This
would not have happened with a true database connection.
The database wrapped in a single document (embedded HSQLDB) is just
fine for drafts and demo purposes. If you really want to work with
this bastard you should save a backup copy whenever you take a break.
Close the file, wait a moment and make copy of it before you reopen
the file.
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Re: [libreoffice-users] Re: Base and new Report Builder in 3.5 · Steven Shelton
[libreoffice-users] Re: Base and new Report Builder in 3.5 · frofa
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.