Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 11 down vote favorite
2

I am having trouble releasing GDB locks in ArcMAP 9.3.

Does anyone know a way to disconnect from all open GDB connections in ArcMap 9.3. I could close and re-open arcMap, but that seems to be a little time consuming.

Has anyone made a button to do this?

share|improve this question
1  
+1 I've tried clearing IMxDocument.OperationStack to make sure no layers reference a gdb connection, but that didn't work. I suspect the problem is with the workspacefactory singleton, but have no idea how to force it to disconnect. – Kirk Kuykendall Aug 25 '10 at 14:41

1 Answer

up vote 4 down vote accepted

2 workarounds: assumption here is personal geodatabase (.mdb)

1.delete the .ldb (whilst Arcmap is open - by removing the layers) delete in windows explorer. Then do 'undo' remove layers. search *.ldb for multiple

2.move up a few folder levels in ArcCatalog and Refresh, it will unlock the file and you can edit in ArcMap.

file .gdb [or .mdb] is at c:\work\project\data, if you view the c:\work\ folder and click refresh in ArcCatalog

Schema Locks http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Schema%20locking

share|improve this answer
Aren't the .ldb files only associated with 'personal geodatabases' (Access db) that have the .mdb extension? I wasn't aware that the 'file geodatabase' format with the extension .gdb used .ldb files. – DavidF Aug 27 '10 at 13:39
1  
file gdb have .lock files Use the Compact GP tool in ArcCatalog to remove .lock files. This removes all inactive .lock files safely. The .lock files can also be deleted with Windows Explorer, the command line, or other file removal or deletion applications. Deleting any files other that the .lock files from the file geodatabase directory renders the database unusable and requires restoration from backup. resources.arcgis.com/content/kbase?fa=articleShow&d=33018 – Mapperz♦ Aug 27 '10 at 16:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.