orbit wrote:
Hi,
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.
Sorry, I probably wasn't expressing myself clearly enough when I said deploy individual copies of the ODB files to each user. The ODB file, when it does not use the native HSQLDB integrated db, serves only as a container for the db connexion configuration data, links to forms, queries and reports. This means that if you are using HSQLDB in standalone server mode, as mentioned previously, you don't need to worry about reconciling data provided that each ODB file remains the same. One way to do that is to configure it with all you need, forms, queries and the like, then make it read only on the user's local file system.
Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
