I am using Base 6.2.5 with HSQLDB embedded. I need to have many people connect simultaneously and enter data. Along comes MySQL. I am almost done rebuilding everything and have created 2 users so far.
Now, once I create the forms, reports, queries in Base, how do many users connect? Do they connect to the one odb file I created or do I have to create multiple odb files (one for each potential user) all pointing to the same schema in MySQL?
Thanks!
Hello Jody
Each user will require their own copy of the ODB file, if they are to be allowed to edit the file itself.
I think one file alone can be shared among the users over network file sharing, provided they get read only access to the file. Also you do not need a unique DB user and password for each user of the application, unless you desire this for stricter security.
Hi Lazarus,
If I understand correctly, I can create one odb file and set it to read-only and users will be able to enter data (i will be the only one allowed to modify the forms, tables, reports & queries)?
MySQL easily supports multi users at the same time. Things you need to think about are better described in the MySQL documentation I think. LO is only a front end. Each front end ‘connects’ to the back end, in this case MySQL server. How you start your front ends is another issue. You can have copies of them, or you can have essentially links that all point to one master copy. BTW, at the same time you can also have other front ends, like HeidiSQL, or MSQL Workbench, or PHP MyAdmin, or even MS Access, all talking to the same tables. Record and/or file locking must be understood for all of this to work.
I updated my original answer. But to answer your comment I give the following response.
If you make use of an embedded database, in the document, and make the document read only, then no one can modify it. This implies that data cannot be entered or modified or deleted nor can you modify forms, views or queries.