Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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


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.