Control application flow. You can design forms that use the file. The number of concurrent users that can be supported depends on the amount of data, tasks performed, level of usage, and application design. Generally accepted limits are solutions with 1GB or less of data (Access supports up to 2GB) and it works pretty well with 100 concurrent connections or less (255 concurrent users are supported). [28] This capacity is often well suited to departmental solutions. If you are using an Access database solution in a multi-user scenario, the application must be “shared”. This means that the tables are in a file called a back-end server (usually stored in a shared network folder) and the application components (forms, reports, queries, code, macros, linked tables) are in another file called the front-end server. Linked tables in the front-end reference the main file. Each Access app user then receives their own copy of the front-end file. Microsoft Access applications can adopt a split database architecture. The individual database can be divided into a separate “backend” file that contains the data tables (shared on a file server) and a “front-end” file (which contains application objects such as queries, forms, reports, macros, and modules).
The front-end Access application is distributed to each user`s desktop and linked to the shared database. In this approach, each user has a copy of Microsoft Access (or the run-time version) installed on their computer with their application database. This reduces network traffic because the application is not retrieved for every use. The front-end database can still contain local tables to store a user`s settings or temporary data. This split database design also makes it possible to develop the application independently of the data. One disadvantage is that users can make various changes to their own local copy of the application, making it difficult to manage version control. When a new version is ready, the front-end database is replaced without affecting the database. Microsoft Access has two built-in utilities, Database Splitter[47] and Linked Table Manager, to facilitate this architecture. ASP.NET Web Forms can query a Microsoft Access database, retrieve records, and view records in the browser. [31] Forms are the primary interface between users and your Microsoft Access 2010 application. You can design forms for different purposes: This article focuses primarily on linked forms. You can use linked forms to control access to data, such as fields or rows of data displayed.
For example, some users may only need to see multiple fields in a table with many fields. Providing these users with a form containing only these fields makes it easier to use the database. You can also add command buttons and other features to a form to automate frequently performed actions. As with other Microsoft Office suite products, Microsoft VBA is the other programming language used in Access. It is similar to Visual Basic 6.0 (VB6) and code can be stored in modules, classes, and code behind forms and reports. To create a richer, more efficient, and more manageable end product with good error handling, most professional Access applications are developed using the VBA programming language instead of macros, unless web deployment is a business requirement. Microsoft Access is a file server-based database. Unlike relational client/server database management systems (RDBMSs), Microsoft Access does not implement database triggers, stored procedures, or transaction logging. Access 2010 includes table-level triggers and stored procedures built into the ACE Data Engine. Therefore, a client-server database system is not a prerequisite for using stored procedures or table triggers with Access 2010. Tables, queries, forms, reports, and macros can now be developed specifically for Web applications in Access 2010. Integration with Microsoft SharePoint 2010 has also been significantly improved.
From the menu, you can create a Multiple Item form, a Datasheet form, a split form, or even a modal dialog box. These are usually linked forms; Select the object you want to link to this form. This does not apply to modal dialog forms. A split form gives you two views of the data at the same time: a form view and a datasheet view. Using split forms allows you to enjoy the benefits of both types of forms in a single form. For example, you can use the datasheet portion of the form to quickly find a record, and then use the form part to view or edit the record. Both views are connected to the same data source and synchronized with each other at all times. A navigation form is simply a form that contains a navigation control. Navigation forms are a great addition to any database, but creating a navigation form is especially important if you want to publish a database to the web, because the Access navigation pane does not appear in a browser.
