topic Re: Geodatabase Stored on Network Drive in ArcGIS Pro Questions

Geodatabase Stored on Network Drive

Ivy_Hinson — Fri, 15 Sep 2023 19:19:35 GMT

Hi, I am the new GIS coordinator and need to be able to remove schema locks and edit geodatabases even when others have the feature class open. All of our geodatabases are stored on a network drive. How would I do this?

Re: Geodatabase Stored on Network Drive

George_Thompson — Fri, 15 Sep 2023 20:19:18 GMT

If this is a file geodatabase, that may not be possible to remove locks (I do not see a way).

Are you seeing these files if you open the "<name>.gdb" folder?

If you remove those files in the folder, you can cause corruption of the file geodatabase. So, I would NOT recommend that you remove those files.

The best bet is to ask all your users to close the clients and do what you need to then. Also be sure to stop any ArcGIS Servers that have services pointing to the file geodatabase.

Re: Geodatabase Stored on Network Drive

ThomasHoman — Sat, 16 Sep 2023 14:05:25 GMT

If these are file geodatabases <dataset>.gdb then you should be moving to a different data method that supports multiple concurrent access - database engines like MS SQL, Oracle, PostGIS, and others support this task. Take a look at https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/types-of-geodatabases.htm . This reference is dated (personal geodatabases no longer supported) but the points are relevant visually https://proceedings.esri.com/library/userconf/proc15/tech-workshops/tw_739-37.pdf

File geodatabases are not designed for concurrent edit access so forcibly removing schema locks sets yourself up for data corruption if you have multiple concurrent editors. The best way to remove the schema locks is to have them exit the application.

Regards,

Tom