Re: [libreoffice-users] Re: Urgent Base problem (stability in long term use)

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