Hi,
I have quite a problem with the Access Driver.
The table consists of 5 columns (with 2 rows):
issueId, timestamp, fk_issueTypeId, fk_transactionId and comment.
When I do
SELECT * FROM tblIssue WHERE fk_transactionId = 2 AND fk_issueTypeId = 2
I get the result:
6 2006-05-31 15:37:22 1 2 hhhhjj
and when I do:
6 2006-05-31 15:37:22 1 2 hhhhjj
Let me know if you need additional test data to reproduce the issue.
Kind regards,
Eric Aili
|
Failed to recur your issue. Please zip and email webmaster@hxtt.com your mdb sample. Thanks.
|
Maybe your mdb file has an invalid index information? You can try Repair and Compact your database in MS Access. BTW, try the latest v1.2.007 released on May 31, 2006.
|
Dear Eric,
I haven't received your sample so that I guess your issue has resolved. More question or requirement? Please let us know.
With best regards,
Yonghong Zhao
Senior Engineer
|
Hi,
sorry for lack of response from me.
I've just sent the sample MDB, where the issue occurs.
Kind regards,
Eric Aili
|
Thanks for your valuable response. v1.2.008 fixed a bug in index result cache. Please download the latest package.
|