just to confirm the solution above from MIKE worked perfectly

much quicker than having to rebuild my distribution database from scratch!!!

cheers