What is the .ldb file to the end?
This article reference address: http://support.microsoft.com/default.aspx? Kbid = 208778 Abstract: The ldb file is very important in multi-user environment. This file is used by MS Jet DB Engine V4.0 to determine which record is locked in the shared database and who locks more information: .ldb file is automatically created and deleted by the user of the shared database. The .ldb file establishes and stores computer names, usernames, and placing extension domain locks. .Ldb files are generally with. MDB the same name, and with the .mdb file in the same directory, set and lock when .mdb file is opened. For example, if you open the C: /NorthWind.mdb file, the c: /northwind.ldb file will be automatically established and locked. When the last user turns off the shared database. The LDB file is automatically deleted. However, when the user has not properly turned off the database or the database has been marked as corrupted, the.ldb file will not be automatically deleted, because the database is stored when the database is stored in the .ldb file, who is using the database. Permission issues: Remember to give the .ldb file where the folder is certain. If you are ready to share a database, the .mdb file should be placed in a directory with read, write, build, delete permissions. Even if you ask each user to have different file privileges (such as read-only or readable writing), all users who can share this data should have permissions, write, and establish permissions, but you can assign users. Only read-only permissions for a .mdb file. Note: If you open a database with exclusive ways, the MS Jet DB will not establish .ldb file, at which point the user's permission to the directory requires reading and writing two permissions. . LDB file content: MS JET DB Engine will create an entry for each user who opens the database in a shared manner, and the size of each entry is 64 bytes. The front 32-byte saves the computer name, and the 32-byte after the latter is saved. The maximum number of users supported by Jet DB Engine is 255, so the .ldb file size will not exceed 16 KB. When a user closes a shared database, the user is not immediately deleted immediately, but the entry is overwritten when the next user opens the database. This means that you can't pass the .ldb file to determine who is the current user of a database. The use of the .ldb file: Jet DB Engine uses the information in the.ldb file to determine who is locked the data, who is writing data locked by others. If Jet DB Engine finds a lock conflict with other users, it will read the .ldb file to get the computer name and user name who locks the file or record. In most lock conflicts, you will get a "write conflict" prompt when you store your record and cancel what you make. In some cases you will get the following tips: COULDN'TLOCK TABLE
