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

2011-09-30 Thread Tom Davies
Hi :)
I don't know much about this but

1.  Is your java version higher than _21?  if so it would be best to install 
the _21 just for LibreOffice OpenOffice.  The more recent ones cause 
problems.  Find out which version by
Tools - Options - LibreOffice/OpenOffice/General - Java

2.  Do you really need a spreadsheet?  A query or even a report can be made to 
look like a spreadsheet?

Regards from
Tom :)


--- On Fri, 30/9/11, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: [libreoffice-users] Calc and Base problems.
To: users@global.libreoffice.org
Date: Friday, 30 September, 2011, 8:24

Hi All

I have a couple of problems I need to solve urgently!!

I have two computers here -

1) Running Mint 10 KDE and Open Office 3.2.1
2) Running Mint 9 KDE and Libre-Office 3.3.2.2

I have developed and am running a Membership Database on a daily basis on 
machine 1and it works perfectly!! I would like to create a Spreadsheet that 
links to the Database. The DB is Registered on the system but if I do a 
'InsertLink to external data', then browse to and select the Database file - 
nothing happens and the 'link box' remains empty. If I do a 'ViewData Sources' 
the whole Open-Office Suite just crashes' totally!! (I use Calc on a regular 
basis also and it works fine).

On my second machine I have a separate copy of the Database file from machine 1 
which is also Registered on that machine. If I try to run the database - 'LO 
BaseOpen existing fileSelect fileOpen' The Base window opens and shows all 
my Tables, forms etc. But when I select any of these I get the following 
error...

Connection to 'My DB' couldn't be established.
GENERAL ERROR: org.hsqldb.lib.FileSystem RunTime Error:
Java.IO Exception: 
/home/tinderbox/ooobuild/build/libre-3.3.2.2/package/source/xstor/xstorage.cxx: 
:3323;

Also if I try to run my Database on this machine I get the exact same error. I 
can select it and the Base window comes up showing all my tables, forms etc but 
if I select anything the error comes up. This is very distressing as it means I 
can not move to Libre-Office if I can't run my Database which works fine in 
OO!!!

Any thoughts or suggestions on these problems??

Thanks in advance

Ian Whitfield.



-- For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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



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

2011-09-30 Thread Ian Whitfield

Thanks Tom

On 30/09/2011 13:11, Tom Davies wrote:

1.  Is your java version higher than _21?  if so it would be best to install the 
_21 just for LibreOffice  OpenOffice.  The more recent ones cause problems.  
Find out which version by
Tools - Options - LibreOffice/OpenOffice/General - Java
   

Machine 1 has Java _21
Machine 2 has Java _20

2.  Do you really need a spreadsheet?  A query or even a report can be made to 
look like a spreadsheet?
   

Would be interested to hear about this.
I need a printable document that up-dates automatically from the DB to 
transfer to my WebSite.


Thanks
Ian Whitfield

--
For unsubscribe instructions e-mail to: users+h...@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