Apr 07 2022 10:37 PM
Is there a server to store tables so that remote users could access and work with them assuming access application is installed on each of them?
Apr 08 2022 06:00 AM
Solution
The short answer is "No", that's not how it works.
The long answer is more nuanced, and it depends to some extent on your requirement.
Access itself contains components to create:
Tables, being only one of the three components, can be stored internally in an accdb in the built-in ACE database engine, or they can be in a different database engine such as SQL Server, or MySQL, or Oracle, and even SharePoint lists. That means it is possible to move your tables from inside the accdb into a database which is on a server. The tables, of course, won't be directly "on the server". They'll be in the database (e.g. SQL Azure) which is, in turn, installed on the server.
Users then can each have a copy of a separate accdb containing only the interface (formas and reports) and logic (VBA) components linked to those tables in the server database.
Apr 08 2022 06:00 AM
Solution
The short answer is "No", that's not how it works.
The long answer is more nuanced, and it depends to some extent on your requirement.
Access itself contains components to create:
Tables, being only one of the three components, can be stored internally in an accdb in the built-in ACE database engine, or they can be in a different database engine such as SQL Server, or MySQL, or Oracle, and even SharePoint lists. That means it is possible to move your tables from inside the accdb into a database which is on a server. The tables, of course, won't be directly "on the server". They'll be in the database (e.g. SQL Azure) which is, in turn, installed on the server.
Users then can each have a copy of a separate accdb containing only the interface (formas and reports) and logic (VBA) components linked to those tables in the server database.