ha ha ha ! Thanks Bruce.
So much for flagging my thread as urgent (thats not aimed at you by the way).

I got there in the end, although I was surprised to learn that not only do you change the database, but you have to use the process to change every table/view used as well.
You would have thought changing things at database level would have been sufficient, especially as one is a mirror of the other so therefore no differences in structure.

Still .... you live you learn.
I'm living ... and I've learnt I hate Crystal Reports
But I hate year end much much much more !!!!!!

Thanks for the reply