Hi again,
I've found what I believe is another bug in the Access 3.0 driver, dated 9/17/2006. When I issue the following select:
select * from tbl_be_tax_rtn
I get one row, which is what the database contains. When I issue a more specific select:
select * from tbl_be_tax_rtn where part_ssno = '080288704'
I get not one row, but *four* rows, each with duplicate data. I've uploaded this database to your public FTP server to aid you in fixing the problem. It's called "Empty Copy of Duty Disability.mdb".
Keith
|
After run "reindex all on tbl_be_tax_rtn;" once,
select * from tbl_be_tax_rtn where part_ssno = '080288704'
become normal.
So that it's resulted by an invalid index.
|
I tested with:
insert into tbl_be_tax_rtn (part_ssno ) values ('080288705');
select * from tbl_be_tax_rtn where part_ssno = '080288705';
It's normal. I don't know what's the invalid index source of your mdb sample, which contains 4 duplicated index information for the same row.
|
Main
webmaster@hxtt.com