FAQ: Can multiple users access a personal geodatabase with a schema lock on it?
Can multiple users access a personal geodatabase with a schema lock on it?
Yes; for multiple users to access data in a personal geodatabase that has a schema lock on it, all users must have the same permissions for accessing the personal geodatabase. For example, if a user opening an .mdb file has write access, subsequent users with read-only permission cannot read the file. If the users with read-only permissions were to open the file first then they would be able to read it, while the user with write permission would also be able to view the file.
If all users have only read-access or if all users have write access, no problems occur. This is a limitation of the jet engine and .mdb files.
For additional information, see the link in the Related Information section for the ArcGIS Desktop Help topic 'Schema locking'.
- How are the various lock mechanisms implemented in ArcSDE and the geodatabase?
- ArcGIS Desktop Help: Schema locking