To make your application available to multiple users, do one of the following:
See Also For more information on splitting your application into a front-end database and a back-end database, see “Separating Your Application’s Tables from Its Other Objects” in Chapter 15, “Delivering Your Application.” For information on linking tables, search the Help index for “linked tables.”
A Microsoft Access multiuser application consists of several important components. In addition to Microsoft Access itself and your application’s front-end and back-end database (.mdb) files, your multiuser application must have:
The workgroup information (.mdw) file is a Microsoft Access database that stores information about users in a workgroup, including their account names, their passwords, and the groups that they belong to.
The location of the workgroup information file in multiuser environments is important. It can either be placed on each local workstation or shared on a network server. However, if it’s stored locally, you must take the steps necessary to update it when security settings change.
The workgroup information file also stores a list of the most recently used databases. If you want your application’s users to have their own lists of the most recently used databases, you should either store the workgroup information file on the users’ local workstations or establish user-level security.
See Also For information on establishing user-level security, see Chapter 14, “Securing Your Application.”
The locking information (.ldb) file stores information about any records that are currently locked in the database.
If the locking information file doesn’t exist when the database is opened, the Microsoft Jet database engine creates it. It creates one locking information file for every Microsoft Access database file that is opened in shared mode. Microsoft Jet gives the file the same name as the database that was opened, but with an .ldb file name extension. For example, Northwind.mdb has an associated locking information file called Northwind.ldb. The locking information file is stored in the same folder as the database. Microsoft Jet deletes the .ldb file when the database is closed. In a multiuser setting, this is when all users have exited the application.