"One of the connections in the transaction is not active"

[DerPaul]

Hi

I have a routine, that every few seconds checks if records have popped up in a table.
Lately is has started to crash and I get an errormessage: "Access violation at address 00556780 in module 'L.exe'. Read of address 00000000".
Next time I try and for ever after that, I get this message "One of the connections in the transaction is not active".

The query is quite simple and short, like this:
Select Batchno
from A_BatchToScan
Where (Expr1 = 1600)
And Not Exists (
Select * from _BatchToScan
where ([A_BatchToScan].[BatchNo] = [_BatchToScan].[BatchNo])
)
Group by Batchno

Anyone ever heard about something like this?

Best regards

Poul

[AlexP]

Hello,

Please send the Delphi code that causes this error, and specify the versions of the IDE and SDAC