What is SQL statement??? This command TOO complex to make any suggestions...
>Out of the blue (meaning that this code has been running for about one year), I run a routine that gives me a Fatal C0000005 error on a SQL select statement. I have searched the threads and found other instances of this occurring. In the past, if we got one on a view opening, we rebuilt our dbc, packed our data and it seemed to clear it. In this case it hasn't. Anyone got some specific info on this and what cause could be.
>
>BTW, if you execute the select from the command window, no problems. In the debug mode where we set step just ahead of the error, the execution of the subsequent SQL statement bombs it.
>
>Thanks for the info.
>
>Bill
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.