
Syntax error the second time I run the query
Quote:
> Hi.
> Is there any known reason to get a syntax error (ErrorCode 3075) when I
> open() an specific RecordSet after I close() it ?
> I get the next error:
> Syntax error in number in query expression "ID = 1 AND Name = 'LUIS''
> Thanks in advance.
This error is the result of a internal timing problem of the Access driver
that has been around since they are useing multiple threads in the jet
engine (Version 2.5 methinks). I have code that catches this exception and
retries the statement until it succeeds. Are you useing the latest Access
driver? I wonder if they ever going to fix this.