Just for clarity for others who may read this.
If you just create the new Dynamic Connection and call it the same name as the existing one then it overwrites it and works just fine. I only say rename the existing connection in case it goes pear shaped. Then at least you still have the original connection to fall back on.