AnsweredAssumed Answered

Can tables in a non-spatial database be edited in ArcMap

Question asked by housewren on Sep 18, 2014
Latest reply on Sep 19, 2014 by housewren

Not sure where to post this; can't seem to find an appropriate Place, and I have searched all over trying to find an answer

 

I have an SQL EXPRESS 2012 instance that has been enabled for geodatabases and have 2 geodatabases in it that work fine.  In the same instance, I recently added another database (non-spatial) that I created in SQL Server Management Studio for which I have made a Database Connection.  I can add a table from this non-spatial database to the map and I can join geodatabase tables to it, but I cannot edit it.  Is there something wrong in the way I have set it up, or is this the way things work?

 

If it is non-editable in ArcGIS, what would be the best way to handle the scenario where data from a geodatabase table is needed to up-date the non-spatial database table, and vice versa?  (The non-spatial database's primary function has nothing to do with ArcGIS, but I would like to be able to work with one particular table from it.)

 

Cheryl T

Outcomes