I have solved it - in a long-winded way!
Created a new site and database + new connection with the same name (worked fine). Copied all the site files across from the old to the new.
Everything working fine now.
Phew!
Thanks you for your willingness to help.
Cheers
Chris