Base as Front End w/multiple users

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?

  • Jody

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.

Some examples:

  • If the Base document is read
    then users can read data but
    not enter or modify existing data.
    Modification of forms,
    queries and views will also be restricted.
  • If the database itself is
    external, as opposed to embedded, then a Base document which is read only can act as the
    user interface to the database. In
    such a setting the Base document is
    used for reading and modifying
    database contents while the
    queries, views and forms remain protected from modification.

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.