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 below into Field Calculator and click Calculate button.

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