Alex Thurgood <[EMAIL PROTECTED]> wrote: orbit wrote: >
No, no, nothing like that. What Mechtilde meant is that you have to install the HSQLDB server on your machine that is going to host as a db server. Then activate it, and configure it with the necessary options. You have to be careful here because you will now have 2 hsqldb.jar files on your machine, the one that comes with OOo, and the one you've installed as a server, and they can conflict and cause OOo not to work properly, certainly at least in earlier versions of OOo2, or earlier versions of the HSQLDB server (below version 0.7 AFAIR). Then you'd have to recreate the connexion from within OOo to the HSQLDB server (specifying user access rights if any). Check out the HSQLDB documentation on the corresponding hsqldb.org website for further details of howk to install and set up HSQLDB as a server process. Thanks! I didn't realize HQSL was a separate project....will look over their website. Never tried the transactional row locking of HSQLDB from within Base so really wouldn't know. The best thing to do is to give each user his/her own copy of the ODB file. Well these are people in a store and one of the goals of a database is to reflect the actual inventory of the moment as people sell and buy stuff, so with individual files, someone might have to gather them up, reconcile them, and then distribute them back to the appropriate individuals. If HSQL is up to it, I'm going to hope Base won't interfere with locking schems as the database is updated. Otherwise, MySQL to the rescue (haven't ruled it out yet, it's just a little overkill for the app and when I go away, someone will have to learn MySQl to be the admin and keep it going. Thanks for the good note! --Paul T.. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
