How to connect to a remote access database?

Question

Remote access

Created a local database in Microsoft Access. I chose this particular base for personal convenience and the possibility of creating forms. How can I connect to this database via a local network and be able to edit it?

Answer 1

database in Microsoft Access

It's just a file. Allow access to it over the network for editing, for example, through folder sharing.

In this case, it will not be possible to edit it at the same time

Ways to share an Access database .

Answer 2

Good. You take a file. You put in it only tables. This will be your base. Further you take the second file, in it you create links on the first. And this is your main working file, where there will be forms, requests, etc.
You will give it to each user by simply linking the tables of the main file. It will work just fine, and then, as you outgrow the access, you link instead of access tables - ms sql tables and happiness will come.
You can think about the option "interface on access, and tables on MS SQL Express" right now.