Re: [libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

Thanks again Tom, really appreciate it.  Using MDB Tools (from the 
Ubuntu repository) I'm able to get a look at the data but not sure yet 
about the relationships etc.  I'll keep your Postgresql advice in mind.

On 10/08/2014 03:18 AM, Tom Davies wrote:
> Hi :)
> Do you know if the Access database has a lot of Tables and 
> relationships between the Tables?
>
> If it's just a few Tables then it might be relatively easy to export 
> them from Access and into a solid back-end such as MySql/MariaDb or 
> better might be Postgresql. There are tons of other good back-ends out 
> there too.
>
>
> Base is designed to be the middle section.  It connects easily to data 
> tables held in a wide range of different scenarios. Then Base does the 
> Queries / Sql logic, calculations and filtering and also does the 
> relationships between tables.  It can do Forms and Reports but it also 
> allows such Forms and Reports to be created in Writer and Calc.
>
> So, normal users only see familiar interfaces.  They don't have to 
> struggle with unfamiliar tools.  They don't have to go on a course to 
> learn all about all aspects of creating a database just in order to be 
> able to flick between different records in the database.  Annoyingly i 
> think that if you want users to input new data then they do have to 
> use Forms and Reports from within Base itself.
>
>
>
> Of course Access uses it's own unique version of Sql so you might need 
> to redo some of the Queries/Sql.  Also the Forms and Reports might 
> need to be redone.
>
> Once you have created such things outside of MS Access then moving 
> between other products is fairly easy.  For example if you started by 
> moving the Tables into Base itself and used it's own internal back-end 
> then it's relatively easy to move them to an external back-end 
> some-time in the future, or between different back-ends.  I think 
> there are some fairly serious problems with Base's internal back-end 
> so i think most experts would recommend either frequent back-ups or 
> starting off with an external back-end right from the start.
>
>
> There is some documentation at;
> https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook
> and on the Faq
> https://wiki.documentfoundation.org/Faq
>
>
> Also it might well be worth poking around on the Apache OpenOffice 
> forums because they have to deal with the same issue too.
>
> Good luck and regards from
> Tom :)
>
>
>
> On 8 October 2014 09:25, Werner <wernerfbd@gmx.ch 
> <mailto:wernerfbd@gmx.ch>> wrote:
>
>     Hi,
>
>     On 10/7/2014 20:46, m. nease wrote:
>
>         Hello,
>
>         I'd like to do some work on Access databases (.accdb files)
>         but haven't
>         been able to access(!) them using Base (and have no MS OS or MS
>         Office--happily).  Is this possible?
>
>     Some time ago I used the "Microsoft SQL Server Migration Assistant
>     for Access"
>     (http://www.microsoft.com/en-us/download/details.aspx?id=42656)
>     together with SQLExpress from MS to get at the data in a MS Access db.
>
>     I just needed to get it into calc, but I would think you should be
>     able to access it once the data is in SQLExpress using the ADO
>     adapter, or in worst case you should be able to export it from
>     SQLExpress.
>
>     Werner
>
>
>
>     -- 
>     To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
>     <mailto:users%2Bunsubscribe@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

--

/Not/ "sent from my iphone".


--
To unsubscribe e-mail to: users+unsubscribe@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