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