Hello,
we have a problem with some data that is not entered correctly in the mdb file.
Situation: We want to write a CUP file (MDB file with predefined schema). The way we do it is that we generate SQL statements and then run the complete SQL statements into the Access database by using your Access driver.
This seemed to work well, but now we found that in some situations the Access file hold some corrupt data. Opening the file with Microsoft Access shows some incorrect and unreadable fields for some columns of some records. (Most of the data seems to be OK.)
Take for example the two following SQL statements:
insert into Cup_PartUpdateCommodity (Cup_PartUpdateCommodityID, CatLevel1, CatLevel2, CatLevel3, CatLevel4, CatLevel5, CatLevel6, AcctLevel1, AcctLevel2, AcctLevel3, AcctLevel4, AcctLevel5, AcctLevel6) values (2, 'Farming and Fishing and Forestry and Wildlife Machinery and Accessories', 'Agricultural and forestry and landscape machinery and equipment', 'Agricultural machinery for cleaning and sorting and grading', 'Other', '', '', '21', '10', '20', '00', '', '');
insert into Cup_PartUpdateCommodity (Cup_PartUpdateCommodityID, CatLevel1, CatLevel2, CatLevel3, CatLevel4, CatLevel5, CatLevel6, AcctLevel1, AcctLevel2, AcctLevel3, AcctLevel4, AcctLevel5, AcctLevel6) values (3, 'Farming and Fishing and Forestry and Wildlife Machinery and Accessories', 'Agricultural and forestry and landscape machinery and equipment', 'Agricultural machinery for cleaning and sorting and grading', 'Cleaning machines for seed or grain or dried leguminous vegetables', '', '', '21', '10', '20', '01', '', '');
These two SQL statements look similar - only a few fields are different. After importing this data (together with some other additional SQL statements) and opening it with MS Access, then the first record looks OK, but the second record seems to have lost the CatLevel4 field, so that the rest of the fields of this record got shifted one field to the left and the last column 'AcctLevel6' is holding unreadable characters.
When we found the problem, we downloaded the latest available build - which was version 2.1.007 with the build from 2007-01-29. But the problem still exists.
If you need some additional information, then give me a note (and an e-mail address) and I can forward to you our template mdb file and an example SQL file which runs in the problems that I tried to describe above.
|
|
Please email webmaster@hxtt.com your samples. Thanks.
|
|
Haven't received your sample still.
|
|
Sorry for delay - samples are sent to you a few minutes ago.
|
Main
webmaster@hxtt.com