Thanks for earlier Ray - appreciate you updating DB so quickly. Its all looking better now - not running the uninstaller, so the Database panel is showing correctly now. And in the server behaviours panel when I click on a recordset behaviour, I can now select the new connection from the drop down.
Couple of things though - the main one being that I the web page isn't connecting still. The hosting company have advised that its not a configuration issue at there end, (Although that seems counter intuitive if the site isn't allowing access?) Link below.
And also, looking at a page with an insert, I don't see a server behaviour for that. I have attached a screenshot showing the server behaviours listed in the panel for the page. Can you have a quick look and let me know if it is showing everything it should be? I may as well make sure everything is as it should be I guess.