This is what I was told when I asked about the capabilities of Base:
Le 17/02/2013 02:38, Mark LaPierre a écrit :
Now how do I create non-linked tables inside the same DB?
How do I link to another external spreadsheet using the same DB?
You would be better off using an external HSQLDB instance to link
directly to text tables (note that these would not be Excel files). See
the HSQLDB manual for how to do this.
Can I link to only one spreadsheet at a time?
In a single ODB file with the embedded hsqldb engine, AFAIK yes.
From your email I gather that all tables must be tabs on the one
spreadsheet that is linked. Is that a true statement? Seems pretty
It is, fairly. But LO Base is not Access, nor FMPro. If you need to work
comfortably with and edit multiple separate data sources, using the
embedded hsqldb is probably not the best choice.