Is there any "Geodatabase in use" checking software out there?

Question

I was wondering if there are any ESRI or third-party software/solutions out there that would could be used to automatically track whether a (non-enterprise) File or Personal Geodatabase was in use, with the idea of avoiding file corruption and lock issues when two or more people accidentally try to use the geodatabase at the same time.  While we do have an Enterprise Geodatabase (SDE) here, we still rely on many file and personal geodatabases outside SDE on the server for various tasks and multiple people need to access them.

What would be optimal is a checking process that activates when a second person tries to access a geodatabase that is in use that would warn them that it is in use and who the current user was.  Something smoother than manually having to go to the geodatabase in Windows Explorer and looking for lock files (and then trying to match the computer name listed as part of the lock file name with a user).

Is there any software/solution out there like this?

Thanks,

Chris Donohue, GISP

blake.terhune · Answer

If it doesn't have to be on the entire geodatabase, you could try using TestSchemaLock() on the feature class or table before attempting to do something with it.

ChrisDonohue__GISP · Answer

Thanks for posting that Micah.  It has possibilities.

It looks like this could be handy not just as a standalone script tool but as a check process to build into modelbuilder (or a python equivalent) prior to it trying to process datasets so as to head off any conflicts.

Chris Donohue, GISP

MicahBabinski · Answer

Zing!!! Love it. We just moved a whole Bureau off of them.