Thanks, Jim
I feel the same way but I think I found the problem. I did not close the cursor after running the sqlexec and creating a table of the Oracle data. In our multi-user maybe oracle sensed the same connection named data or there was a network lock on that name. Yea its out there but I am reaching. The problem only happens intermittently and when 2 or more users are in this same app. Sorry for the late response, office Christmas parties and all you know.
>>I have an interesting dilemma. I have an application that on edit or add, connects to Oracle to verify accounting codes on input. Out of nowhere we start getting an "access denied" error when trying to create the Oracle cursor. I renamed the production exe and copied the source exe to the production directory. No more error and everything is fine. How does an executable get corrupted? Its another notch in my supervisors attitude that we need to dump VFP! Help...anyone
>
>Hi Chuck,
>
>I just want to say that any EXE can be "corrupted" - the OS even offers "repair" features for it's own stuff!!!
>
>"Access denied" could just as easily come from someone tampering with security settings too. Or possibly even something so simple as manually moving a desktop short-cut from one "Documents and settings...." folder to another.
>I sure have trouble equating "access denied" with corruption of an EXE.
>
>good luck
Extreme Programming = Plan -> Design -> Code -> Test