To check the database, we open the mdb file under Windows with Microsoft Access. We filled the mdb file by usage of the HXTT Access JDBC driver (the download from 22th february 2006). When opening a table overview for one of the tables, everything seems to be OK. But when trying to sort columns (e.g. right mouse on the header of a column and select 'Descending') it could happen that all records in the active view seems to get lost.
Actually the data records are not lost, it is possible to open the table view again. But it is not possible to sort by this column in the new view, either.
Only a few columns behave like this. Most of the columns allow sorting!
If this error occured for a column, then it is reproducable for this column (even when restarting Microsoft Access). But it could also happen that another mdb file - filled with the same peace of code - doesn't show this problem.
After running 'Database compress and repair' it is possible to sort the columns that showed this problem. But opening every exported file in Microsoft Access and 'repair' it is no solution.
Do you know what is going wrong here? Any idea on this?
Thanks,
Norbert
|
We haven't recurred "all records in the active view seems to get lost" still, but have recurred "part records in the active view seems to get lost" by 'Descending' sort columns. You should are using JET4(MS Access 2000, 2003, XP, and so on), and that column should be an indexed text column. We're digging out to find why there's minor incompatibility, and that issue should be resolved in 48 hours. Thanks for you patience.
|
Supported now. Please download the latest package.
|
I did some tests and couldn't reproduce the problem anymore. Seems to be solved.
Thank you for your quick help!
|