To change absolute paths in spatial data source catalog open the catalog as table, click on IMAGE field and choose Calculate command. After this simply put script text bellow into Field Calculator and click Calculate button.

StringList sl;
[IMAGE].SeparateToList("\\", sl);
Number nCount;
sl.Count(nCount);
nCount = nCount - 1;
sl.Get(nCount, [IMAGE]);