topic Re: Attribute Table: Delete Field not Working? in Geoprocessing Questions

Attribute Table: Delete Field not Working?

SamanthaM — Tue, 27 Mar 2012 14:39:33 GMT

I am trying to delete a attribute table I created, but its not working for some reason. I am right clicking the field that I want to remove, and I select delete field from the drop down but nothing happens.

[ATTACH=CONFIG]13051[/ATTACH]

Re: Join: Generating Records [pictures]

SamanthaM — Tue, 27 Mar 2012 17:10:11 GMT

User error, just noticed when I formatted the table in excel I removed a zero.

Re: Attribute Table: Delete Field not Working?

DanLee — Tue, 27 Mar 2012 20:40:22 GMT

What version of ArcGIS are you using? Can you try the Delete Field tool (Data Managment toolbox - Fields toolset)? If that doesn't work, could you share your table?

Re: Attribute Table: Delete Field not Working?

SamanthaM — Tue, 27 Mar 2012 20:49:40 GMT

What version of ArcGIS are you using? Can you try the Delete Field tool (Data Managment toolbox - Fields toolset)? If that doesn't work, could you share your table?

Thanks for stopping by, I appreciate the help. I am using ArcGIS 10. I attempted to the delete field tool and that did not work either. The field is part of the shape file, not a join just to clarify. I have attached the shapefile to this post. The field that needs to be removed is "Text", the last colum

Re: Attribute Table: Delete Field not Working?

DanLee — Tue, 27 Mar 2012 21:04:32 GMT

I downloaded the data and deleted the Text field in the Schools2010.shp without a problem. I used 10.0 SP3.

Can you try restart ArcMap and try deleting the field again? Also you can try the Copy Features tool to make a copy of the shapefile and try to delete the field again. Does that work?

Can you add another field using Add Field tool and then Delete Field to delete that new field?

Re: Attribute Table: Delete Field not Working?

SamanthaM — Tue, 27 Mar 2012 21:32:50 GMT

I downloaded the data and deleted the Text field in the Schools2010.shp without a problem. I used 10.0 SP3.

Can you try restart ArcMap and try deleting the field again? Also you can try the Copy Features tool to make a copy of the shapefile and try to delete the field again. Does that work?

Can you add another field using Add Field tool and then Delete Field to delete that new field?

I attempted restarting the program/computer and using copy features. In addition I used various other different shapefiles, added fields and attempted to delete them with no success.

I believe I am using SP 1 at the moment, where do I verify what SP I am running? I am not sure if this is a known issue but I will go ahead and upgrade the latest SP and hope it resolves this issue.

EDIT: Upgrading to SP4 fixed this issue, must have been a bug

Re: Attribute Table: Delete Field not Working?

DanLee — Tue, 27 Mar 2012 21:56:18 GMT

I am sorry about the trouble you run into. Hope the upgrade will help. To check your SP version in ArcMap, click Help (top of the window) and select "About ArcMap ..."; you should see "ArcGIS Desktop 10 Service Pack # (Build xxxx)".

Have you tried to re-download the data to a new folder and try again? Perhaps you have processed something that has caused the "lock" on this data.

Re: Attribute Table: Delete Field not Working?

DanLee — Tue, 27 Mar 2012 23:02:12 GMT

I didn't see your edit before submitting my answer. I am glad the problem is gone.