> Just like MSAccess, Base is extremely useful as a frontend for > database engines.
The last time I tried to run a non-trivial query (involving a join) from Access against PostgreSQL, the result was a never-ending cursor animation. It seems that Access fetches *all* records from the database and runs the query locally. > You must not use the built-in JET engine with Access. HSQL is an > excellent platform independent database engine but you must not embed > HSQL in extensions which are installed and repackaged every time you > "open" or "close" the so called "database document". "Embedding" databases anywhere is imho nonsense. Database *content* can imho be passed around between users in a pretty fool-proof way as a zipped SQL dump, if required. Sincerely, Wolfgang -- For unsubscribe instructions 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
