Managing Schema Locks

[MikeMacRae]

Hey everyone,

I know managing schema locking is an issue to be addressed with ArcGIS between users, but I'm should there be a schema lock between maps that a single user is working in when working in a file or personal geodatabase

For example, I have 2 ArcMap docs open. Both have the same point feature class in it. The first map is the map I am creating (i.e. a figure for a report). The second is a blank map that only has the point feature class in it. I like to work in a blank map to do edit the point locations. When I start an edit session, move a few points and then go to save; I get a schema lock because I have the points already in the first map. Can I override this somehow?

Thanks,
Mike

[MichaelVolz]

Could you possibly create a replica database that you would use for the report datasource?

Then you could make the changes to the parent geodatabase and just push the changes to the replica database with a tool and then refresh the report map document.

[BirajaNayak]

Hi,

This is expected behavior on file or personal geodatabase. The same workflow is possible if data is stored in ArcSDE geodatabase.
On this situation, you can edit point feature class on the same mxd ( for report). You can  uncheck the display of other layers in mxd while editing the point layer which is like editing the point feature class in a blank mxd.

Regards,
Biraja

[MikeMacRae]

Thanks for the suggestions!

Michael, in my office environment, using a replica database and loading the original one later opens up a can of worms that I prefer to stay away from! I've done this before and in theory it works as you envision, but sometimes things get to chaotic and somebody (me) may forget to load or replace the original geodatabase. I'm basically trying to dummy proof myself 🙂

Biraja, ESRI creates to many issues when working in the figure with all layers. Turning off the layers except the one I want to work on doesn't always work. I've had issues ranging from layers not being selectable to selecting the wrong layers. I get weird trace issues (the trace tool sometimes likes to trace layers that are turned off) and I've had other weird occurrences happen when working editing in my figure, so I like to stay away from that. Editing in a separate map document allows me to work on my edits relatively trouble free and the I can refresh my figure map document to see the results. The schema locking is a pain in the rear end!