"One of the connections in the transaction is not active"
Posted: Sun 16 Mar 2014 14:23
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
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