Re: [libreoffice-users] Re: Base can't open databases

Hi :)
Ouch sorry for double-posting and nothing hugely useful in either.  

Base is better when the back-end is separate from the front-end.  Base is a great front-end.  There 
are a lot of choices for back-ends and i have no idea which is best for a simple small database.  
SqlLite, HSql(db?) or something?  

A new guide to Base is being written but it's slow going.  The 1st chapter is available at
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
There is a tutorial just under it on that page.  

Base can use an embedded back-end just like Access does but it's not as good that way apparently.  
I think the back-end is basically the table and perhaps the relationships between tables but i'm 
not completely clear yet.  I think the front-end is the gui, queries, forms, reports and all that.  
Somehow i doubt it's quite that straight-forwards!  

Getting forms and reports from Access to Base is not easy.  I think you basically have to re-write 
them.  I'm guessing/hoping that Queries can possibly be exported as Sql statements and then 
imported and tweaked.  Access doesn't follow Sql standards in it's implementation so it might be 
easier to just re-create them too.  

I have been wondering about trying to access works simple but messy database through Base and just 
set-up queries and stuff that are less problematic so that we all write to the same data-source.  I 
have a feeling that it might be easier to move the data to a new back-end and then get Access to 
read that rather than to use it's embedded back-end.  

So, this thread has been interesting and good to see.  
Regards from
Tom :)


--- On Wed, 14/12/11, Michael Bogaerts <info@bogy.be> wrote:
From: Michael Bogaerts <info@bogy.be>
Subject: Re: [libreoffice-users] Re: Base can't open databases
To: users@global.libreoffice.org
Date: Wednesday, 14 December, 2011, 12:20

Hey Alex,

Thanks for the info..
But since i'm using CALC in a production environment i don't want to go 'trying' with beta releases 
...
I could though use a VM and see if it works there ...

Also; i thought that the tables were converted to ODF; but clearly they're not when i read your 
comments...

Is there a way to fully convert an MDB to ODF without keeping 'links'???
because actually that's what i wanted to do in the first place...

If i need an older version to do that, no problem; i'll temporarily install OO.O or so in a VM and 
do it with that, so that in my production environment i'm permanently freed of this MS 
dictatorship...

Thanks again for all your good help!

Met vriendelijke groeten,

Michael Bogaerts

------------------------------------------------------------------------

De bij ons als "Alex Thurgood" geidentificeerde tegenpartij wist exact op 14/12/2011 10:39 uur het 
volgende uit de vingers te tokkelen:
> Le 14/12/2011 09:31, Michael Bogaerts a écrit :
>
> Hi Michael,
>
>
> >         with LibOffice.I removed OO.O first and then I installed LibOffice 3.4.4 (the
> >         latest release).Since that day i can't open my database files anymore; i can't
> >         read the original MDB files, nor can i open my odf files... well,
> >         i can open the odf files, but as soon as i open a table i get an
> >         errormessage. (it's dutch though, so i'll translate it for you
>
> MDB file access, in fact the ADO, Access2003, Access2007, accdb file access was all broken in the 
> 3.4.x versions up to and including 3.4.4.
>
> Several fixes were entered into the master code branch for the upcoming 3.5 release, which appear 
> to have solved this problem (still not perfect, but at least it now works - well in the tests I 
> managed to do anyway). You may want to test with a beta release of 3.5 to see if you work with 
> those files again.
>
> I don't know whether the fixes are going to be integrated into a 3.4.5 version.
>
> Alex

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