"No Editable Layers" when editing DBMS table/view in ArcMap

KenBurcham

Hi,

  We have a number of databases in addition to our sde geodatabase and we often create a connection to and pull in these non-sde tables and views and use the data as layers, etc.  It seems that we're unable to edit these tables through ArcMap.  When we try we get the error "no editable layers".  These tables are editable by the same user using SQL tools, so permissions are fine. 

  I guess my question is this:  Can ArcMap edit non-SDE tables from other databases?  It seems like it should be able to, but just isn't.  Maybe there is something I'm missing?  I've read docs and surfed the forums but coming up empty.

Thanks!

ken.

KenBurcham

After all the stuff we tried and researched, it seems that editing foreign table data in ArcGIS Desktop is not supported in 10.1.  I read somewhere that it might be supported in 10.2. 

I did find that if I create the database table from ArcGIS desktop I can edit it.  I can also (and don't try this at home) add the table manually to the geodatabase metadata that tracks tables then I could edit it.  But since that would be a very unsupported scenario, we didn't want to go down that road. 

So we're solving our editing via a web application.

Hope that helps!

ken.