We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Base as Front End w/multiple users

asked 2019-07-28 03:00:30 +0200

jodybingo gravatar image

updated 2020-09-03 15:49:30 +0200

Alex Kemp gravatar image

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! - Jody

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-28 13:38:42 +0200

lazarus477 gravatar image

updated 2019-08-06 08:54:04 +0200

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 only 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.
edit flag offensive delete link more


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)?

jodybingo gravatar imagejodybingo ( 2019-07-28 16:54:08 +0200 )edit

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.

EasyTrieve gravatar imageEasyTrieve ( 2019-07-30 20:33:11 +0200 )edit

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.

lazarus477 gravatar imagelazarus477 ( 2019-08-06 08:59:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-28 03:00:30 +0200

Seen: 1,307 times

Last updated: Aug 06 '19