I don't think this is an issue because I am creating the connection on the fly. I have two SPT statements. One is for viewing only that second is for updating. The user logs on and the view only is the default, every thing is fine. The user clicks on the Edit button the second SPT runs, the user makes changes, clicks done and the code =TableUpdate(.T.,.T.,"as400_guery") runs. Again all is well up to this point. Now the code trys to go back to the default state. It runs the view only SPT and an error occurs that the statement is not prepared(why not it ran okay just a second ago?). Again this is only happening on a particular machine.