thanks for replying,

I have solved the problem, I did not have access to the source code so I could no see what was going on. I found a connections in the dbc that was over ruling everything I was trying. I altered this connection and everything worked fine
Stuart