Frequently asked question

Is it possible to set different permissions (read-only, read-write) for different users accessing a personal geodatabase?

Last Published: April 25, 2020

Answer

Yes, however users will run into Microsoft known limits:

1) If a user with read-only access views an .mdb in ArcMap first, and a full-permissions user opens it second, the second user will not be able to edit the Personal Geodatabase. All users will be able to read the document only.

2) If a user with full permissions to the .mdb views it first, any users with read-only privileges cannot view the .mdb at all. Other full-permissions users will be able to view the document, but only one such user can be in an edit session with the same .mdb at any one time.

Personal geodatabases will have these limitations in multi-user environments. In order to have many users view and edit the same geodatabase without affecting each other, use an enterprise geodatabase in ArcSDE.

Article ID:000006361

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic