Access data base tables, forms, queries & reports from another computer

Hello, this is my first go at Libre Office Base.

I have been able to create a table, form, query and report on my laptop and it works just great.

I want to know how can I access / edit these modules from another computer on the network.

Thanks & Regards
Neeraj

Short answer: I think you can’t.
.
What you can do is using any solution to login your remote computer and use the current setup. From Teamviewer to ssh-session a lot of possibilities.
.
Obviously you can also copy an .odb to other computers and use it there, but that is a copy. If you use embedded databases you also have a copy of the data. One can use file-sync utilities or services like dropbox to sync between clients, but theese are not meant for concurrent use ( more than one user at a time).
.
Usually one uses a network accessible database like MySQL/MariaDB for multiple users and all connect to this database over the network using their copy of the .odb or an external form.

1 Like

Any database, which isn’t controlled by a server, could only connected by one user for changing, deleting or inserting data. Special for a Base file on another system you will need whole access to the files on this system, because the database file will open on the laptop by an external pc. It will create a file in the temporary folder, it will load the data in ram …

Base is a tool to work with database. Base is not a database on its own. I guess, you have a Base document with an embedded database of type HSQL or Firebird. Have a look at the status bar of your main Base window. Sharing an embedded database does not work. This simplified, serverless setup is for a single, almighty user on a single machine. Every time you open such a document, a copy of the embedded database is installed to a temporary folder on your local system.

Install the same version of LibreOffice on other computers and use files stored on the network. You might need a script creating/removing temporary lock files to prevent concurrent access to the files