[libreoffice-users] Re: Calc and Base problems.

Am 30.09.2011 16:03, Don C. Myers wrote:
> Hi Ian,
>
> First, there are far more knowledgeable people responding here than I
> am. But here are a few thoughts from reading this thread. These
> suggestions are from my having used a database similar to yours for
> years in Open Office, and since roughly 6 months in LibreOffice since I
> switched from OpenOffice. I copy my database to 3 other computers
> running LibreOffice (I did the same thing when I was using Open Office)
> and I've never had any issues at all on any of the computers. So your
> doing it should work perfectly fine. I also don't think this is a Java
> issue. I'm assuming you have both LibreOffice and Open Office installed.
> I've never had both on the same computer at the same time. When I moved
> to LibreOffice, before I installed it, I removed Open Office. Maybe
> there is a conflict on the second computer since I see ooobuild in the
> path below. The second thought is maybe LibreOffice actually isn't
> finding your database on the second computer. I would compare your
> setup, paths, etc. on the first computer with the one on the second
> computer, and make sure on the second computer LibreOffice is looking in
> the right place for the database. I always have a folder under
> home/documents/Database where I keep my database on all of the computers.
>
> Don

Don,

1) I run 5 versions of OOo (2.4.3/3.3/3.4beta) and LibO(3.3/3.4) on the 
same machine without any trouble nor conflict. OOo 2.x, 3.x and LibO 
behave as independent applications so I can run them at the same time. 
If it were a Windows machine I would run MS Office, Word Perfect or 
whatever as well.

First of all you should be aware about the database you are working 
with. No, Base is *not* a database. Your database is indicated in the 
status bar of the connected database document. If it claims to be 
"embedded" then you need to understand that you are working with a kind 
of plug-in that installs an external database.

2) I was not talking about the folder where to store the so called 
"database document". I was talking about the folder where the *true* 
database gets extracted to while you start up your embedded HSQLDB. Base 
is *not* a database program. You never work with Base. You *always* 
utilize some office features in order to work with some external 
database, even when it claims to be an "integrated" or "embedded" database.
I strongly recommend to abstain from this type of database except for 
demos and drafts.

Demo proposal (1 minute of time):
Look up your temp. folder in Tools>Options>Paths and open that folder in 
your preferred file manager.
Open any of your "integrated database documents" (status bar: embedded 
HSQLDB).
Open any object table, query, form or report in your database.
Watch the temp. folder. This is the place where your HSQL database 
actually lives.
Close the "integrated database document" and watch the database 
disappearing.
The database will be lost when any office component crashes while the 
database gets installed or repackaged respectively. Databases grow over 
time. The larger the database, the more likely you will lose the entire 
database so you need to restore it from backups.

3) In a Windows network I run a HSQLDB server and many clients. Each 
client writes to the very same database simultaniously through 
LibreOffice forms (could be any other database forms as well, Access for 
instance). No matter which component crashes, there can not be any data 
loss except the currently edited records. Of course I run daily backups, 
but only on the server machine. On the clients there is nothing to save.



--
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