Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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

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;
and on the 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 <> wrote:


On 10/7/2014 20:46, m. nease wrote:


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" (
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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.