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 <[email protected]
<mailto:[email protected]>> 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: [email protected]
<mailto:users%[email protected]>
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: [email protected]
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
