FAQ: What operations are not supported for OLE DB data sources or text files in ArcGIS?
What operations are not supported for OLE DB data sources or text files in ArcGIS?
OLE DB data sources include connections to RDBMS and ODBC Data Source Names (DSN) connections.
The following operations are not currently supported:
· Editing the data
· Adding columns/rows
· Select By Attribute in ArcMap
· Full participation in a relate operation with spatial data
These data sources can only participate in a relationship with a spatial data set where the relationship is owned by the spatial data (on the left side of the join). Selection sets made on the spatial data cannot be propagated to the related table. The identify tool may be used instead to query the related data.
· Copying and pasting OLE DB tables or text files