Collaborating in my office; multiple users, multiple roles

Greetings

A senior in my office wants me to develop a database application preferably using MS Access. I have never used MS Access in my life. I have used some MySQL and mostly these days I use LibreOffice (Calc and Writer) for my works.

As pointed out in the comments I can use LO Base.

The senior very vaguely told me his requirements (if I understood him correctly) as follows:

  • User A (the data entry operator) gets a list of tasks, he inputs those in the table.
  • User B (the supervisor) distributes the tasks to users C,D,E, and so on.
  • Users C,D,E,… (the clerks) work on those tasks and finally updates the task as completed (status).
  • At any point of time any user (be it the supervisor or the clerks) may check the status of any task - whom it is assigned to or what is its status.

So, for my requirements -

  1. Do I need to install LibreOffice Online?
  2. Do every user needs to use Base?
  3. In a bird’s eye view, how should I set up the “solution”?

We have an old PC which we can use as a server. We are somehow familiar with both Linux and Windows.

Try Professional Support

Your specification is not detailed enough. Using a server suggests a real database software on the server PC. Then you can use Base on every client PC buit other frameworks can do the job like Django (Python) or Perl with the DBD and DBI packages.

If there is really a DB application, don’t expect to manage it with Calc.

Please do not use Add Answer but edit your original question to enhance the details of your question (answers are reserved for solutions to a problem on this Q&A site).

@ajlittoz Then you can use Base on every client PC Okay and what about in the server? Do I need to install something there as well? Users in our office use MS and my senior wants me to do something with MS Access. However, I have never used Access or even Base. Though I have always preferred LO, so I can try using Base.

Base is LO equivalent to M$ Access.

The server must be configured with MariaDB, MySQL, PostgreSQL or other shared DB app. I exclude SQLite because it is rather single-user and doesn’t manage concurrent access.

Depending on what you do on the client PCs, you may need to install also a web server on the the server PC. Depending on the server age, you may be forced to use “light” apps so that it remains responsive. thttpd is a very good choice if you have no Java scripting on the host (I have tested it with Perl and PHP). Other choices are Apache (quite heavy), lighttpd, Nginx (excellent but a bit tricky to configure), Cherokee, …

Experiment with a simple single-user configuration: SQLite on the server (to be later changed to a multi-user-capable server) and Base/Access on a client PC.

Looks to me you should investigate to see which applications already do the requested job instead of trying to develop something from scratch:

  • Collaborative software: Atlassion Confluence, Discourse, Drupal, IBM Lotus Notes, M$ Outlook, Teamwork.com, …
  • Workflow management systems
  • Prject management: Apache Allura, GanttProject, MantisBT, OpenProject, Project.net, Trac, …

I have not used many of them. This in no way recommends such or such vs. this one. The list results in a quick’n’dirty internet search. Compare your needs to the app features and experiment by yourself.

Using an existing app is much faster and more reliable than implementing your in-house application.

To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.
{"cc_re__cc_re__cc_by_sa_3_0_le": ["pan>\n        </li>\n        </ul>\n      </nav>\n      <p class='powered-by-link'>Powered by <a href=\"https://www.discourse.org\">Discourse</a>, best viewed with JavaScript enabled</p>\n    </footer>\n    <div class=\"tdf-footer-legal\">\n  <hr>\n  <p>\n    <a href=\"https://www.libreoffice.org/imprint\" target=\"_blank\">Impressum (Legal Info)</a> |\n    <a href=\"https://www.libreoffice.org/privacy\" target=\"_blank\">Datenschutzerkl\u00e4rung (Privacy Policy)</a>\n    \u2002\n    Content on this site is licensed under a <a href=\"https://creativecommons.org/licenses/by-sa/3.0/legalcode\">Creative Commons Attribution Share Alike 3.0</a> license.\n    </p>\n</div>\n    \n  </body>\n  \n</html>\n"]}