Greetings Mark,
I am puzzled at what you posted in reply to my original message...
I was talking about a desktop database as the front-end in a Client/Server
application.
It appears your question was with using spreadsheets as a database table.
Did I not understand something that was intended?
Sincerely,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
Mark LaPierre wrote:> Oops! I meant to send this to the list.
This is what I was told when I asked about the capabilities of Base:
"
Le 17/02/2013 02:38, Mark LaPierre a écrit :
Hi Mark,
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.
http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter
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
inconvenient.
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.
Alex"
YMMV
--
For unsubscribe instructions e-mail to: users+h...@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
