A database created in Microsoft Access is used to collect and manage various data. Data in Access can consist of various objects (tables, queries, and forms).
Instructions
Step 1
If you want to use the database on more than one computer, you must configure a specific mode of using the data over the network. This can be done in several ways.
Step 2
One way is to separate the data in the system. In this case, the database tables are located in one Access file, and all other objects - in another file, which is used as an external database containing links to tables from the first file. Each user has their own copy of the external file, and only tables are shared. This solution should be used when there is no SharePoint or content server.
Step 3
Create a dedicated network folder. With this solution, the database file is available to everyone, and users can use it at the same time. However, if you change the same objects at the same time, a conflict will arise. Use a dedicated SharePoint site. When using a SharePoint server, more convenient access to information is provided, as well as conflict-free editing of database objects is guaranteed. Place your datasheet on the internet, save your database through a document library, or work with SharePoint lists.
Step 4
Use a data server to ensure the best possible use of the database over the network. In this case, you will need a server for information, as well as an Access application on each user's computer. Also use special passwords to completely protect the databases, as well as all the data that is in them. Which solution to choose depends on the capabilities of your network and the tasks set. It is optimal to use an option that does not cause conflicts between tables and relationships between them.
