MS Access database application configurations
There are several configurations an MS Access database application can have, such as the following:
- Single-file application/data: The application logic, forms, queries, reports, and data are all contained in a single MS Access file. This works fine if there's only one user and not a lot of data. Usually, we can access data quickly. If the file gets corrupted, then you may lose both the application and your data permanently, especially if a regular backup regime is not adhered to.
A small home-based company may use this configuration for the inventory and sales data when they are a new start-up, often using ready-made database templates that are available for free as part of the MS Access installation.
- Multi-user/single-file application and data: A single MS Access file contains both the application and data, as described earlier; however, there are two or more concurrent users using it at the same time. It is...
