Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html).
Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alper <hankal...@gmail.com> wrote: > Hi Alex, Mark, Tom, > You guys scare me ! I'm beginning to think I'd better start looking for a > new back end. I've put a lot of work into this project. Tom, this is not a > small database like an address book. After normalizing, my design has 16 > tables.( with a few more coming as I've discovered as I feed more data > into it.) If I connect to an external server is there any way I can save my > forms and reports? Or shall I have to start anew ? My tables, queries and > views were all produced using SQL and I have text copies of all of them to > feed any server I might select. Transfer of data becomes a problem, of > course. > Hank > > On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood < > alex.thurg...@gmail.com> wrote: > > > Le 21/01/13 16:01, Mark Stanton a écrit : > > > > > Isn't hsqldb *still* a (relatively) good choice, as long as it is > > installed and > > > used *external* to Base? That does of course mean it's still not the > > "default" > > > setting. > > > > As I mentioned in my answer to Tom, if you use an external version of > > hsqldb, it can only be the same version number as the internal version > > provided with LO, else the old ODB files can no longer be opened. In > > other words, you can not install an external hsqldb jar and expect your > > old ODB(hsqldb) files to keep working, as this will throw an error. > > > > So yes, it still remains a possibility, but one that you may want to > > avoid if you still have old ODB files that use the internal hsqldb with > > an older revision number than the externa jar you plug into LO. > > > > Alex > > > > > > > > -- > > 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 > > > > > > -- > 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 > > -- 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