Thank you for Drobo Comments
So, thank you one and all for all of you comments which I will be taking into account when I replace my Drobo Pro which maybe sooner rather than later as I cannot afford the chaos that it brings all too often
I have just been sent a link to Team Chase's solution to dealing with data
A server is indeed the way to go, join me on my journey to find a reliable cost effective solution