Ok, here's a mind boggler (atleast to me)!
I am using VB's adodc component to connect w/ Access 2000. My table is set up w/a primary key which is simply an auto-incrementing field. When I add a new record it appears to be appended to the end of the table. . . . BUT . . when I move back through the recordset that is not the case!
I currently have aprox. 200 records in this table. When I "add new", "update", and "move last," my new record does not appear. Infact, instead of showing up as the 201st record, it shows up as the 130th (or so) record. If I check its index in ACCESS it is indexed as record #201.
Any ideas? What am I missing here?
I am using VB's adodc component to connect w/ Access 2000. My table is set up w/a primary key which is simply an auto-incrementing field. When I add a new record it appears to be appended to the end of the table. . . . BUT . . when I move back through the recordset that is not the case!
I currently have aprox. 200 records in this table. When I "add new", "update", and "move last," my new record does not appear. Infact, instead of showing up as the 201st record, it shows up as the 130th (or so) record. If I check its index in ACCESS it is indexed as record #201.
Any ideas? What am I missing here?