Dorin,
Many thanks for all your help. I've appended the corrupt table into a new file and seems to be well now.
I'm just a bit annoyed that this corruption doesn't create an error, so it's down to the users to spot that the corruption has occurred.
Many thanks again
Rob