Hi
I think Base is better when you use an external back-end. The Postgresql
people made the effort to work with LO devs to make a native connector that
is built into LO. MySql is another commonly used database program but it's
owned by Oracle so it might be better to go for the drop-in replacement,
MariaDb instead of MySql.
The problem with the internal back-end is that it's been known to have
issues such as data-loss!! Not good for a database program!! The devs are
working at replacing the current ancient, warped version of HsqlDb with an
up-dateable version of Firebird but apparently that runs into problems too
at the moment, at least last i heard which was several months ago.
Base was originally designed to never have an internal back-end but so many
people grumbled that it was alien to Access users that the Sun devs tried
to squeeze in something but then found they didn't have the time and
resources to make a good job of it.
So, i think i'd suggest exporting the Tables from Access directly into
Postgresql or maybe into MySql/MariaDb.
I've forwarded the question to the Users Mailing list to see if anyone
there can help Peter with this.
Regards from
Tom