SDE standalone table update

[NancyGnanicys]

I have a standalone table in ArcSDE 10.0 SP2  that is participating in a relationship class with a feature class layer also on SDE using SQL server 2005 that I need to update regularly. I have admin rights to this. The information of updates comes in MS Access.  I have a OLEDB connection set up and when updating a feature layer I just join and then use field calculator to change the necessary fields (which I would also like to find a more automated way to do but I will get into that one later).  The issue I am running into is when I try to do the same thing and join the MSA table to the stand alone table in SDE, ArcMap just crashes, therefore unable change fields using field calc to import the info from the correlating fields.  What am I missing here that causes the crash for field calculating (in edit session) of stand alone sde tables? 

Second, in order to try to more automate the updating of fields in other feature classes  I came across this article on "what types of data can be editing using SQL" in arcgis resources and saw that maybe this was because the table participated in a relationship class, however so does the feature classes that I perform the same edit>join>field calc process and that works fine.  Both tables and feature classes I have done this on are registered as versioned as well.  It must be possible to do this since manually typing in data for 200+ rows of data would be crazy.

[JakeSkinner]

Hi Lynn,

Does the crash occur when you attempt to create the join, or after the join and you attempt to run the 'Calculate Field' on the SDE table?

I would first recommend trouble shooting this issue by copying the SDE table to a File Geodatabase (the relationship class and feature class will copy along with it).  Then test to see if you can perform the join and calculate field.  If this works, the problem may be with SDE.  If it still fails, the problem may be with Access database.

[NancyGnanicys]

"Does the crash occur when you attempt to create the join, or after the join and you attempt to run the 'Calculate Field' on the SDE table?"
The crash occurs after I join the tables and run the 'calcualte field', it will appear to start processing but then crashes shortly after.


Okay I tried your suggestion and it works fine in the file gdb so the issue lies on SDE. I decided to create a test stand alone table in SDE and a test table in MS Access and the process worked fine as well.  I'm not sure if it was because the test I created only had 3 records in it versus the actual table I'm updating having 200+ edits and over 30k records and SDE gets overloaded? What else could I do allow the changes? 
Could the issue  of editing have to do with the table participating in a relationship class and contains indexed fields?

I just attempted to do a checkin/checkout and the finicky sde table checked out completely blank, it kept the fields but nothing else was there. I'm the only one with editor on sde capabilties but I thought I'd set up a place for myself to edit on.  I haven't tried the other SDE based replica creations since I don't want to have to edit, then synchronize changes, it seems redundant right? (Edit: I have read some information about replicating related data and it seems that it is rather a very tangled web which is probably why the check out did not work out well for the table).

[JakeSkinner]

Hi Lynn,

When checking out a table, you will need to go into the advanced option of the 'Create Replica' wizard.  By default, table's are checked out with the option 'Schema Only'.  You will need to change this to 'All Records'.

[ATTACH=CONFIG]17669[/ATTACH]

[NancyGnanicys]

Oops, ok now it works.  Thanks!