It works just fine, however it's very loose when connected to any RGB out port (even to A500's!) but especially on the A4000 RGB out!
If I were you I'd look for an RGB to Scart or RGB to composite/s-video cables, depending on where you live (Europe or N. America). It won't look so bulky in the back of the A4000 as it would with an A520 adapter.