I am using VB6 and DAO with an Access data base with just a few tables.
I have occasion to add data to a table and then read the data back after the final UPDATE. Frequently I will not get all the data back if the read occurs right after the UPDATE and I am wondering why?
For example, I add 12 records to an empty small table (8 fields per record) which includes one field which is simply a counter to tell me the number of the record. I then open the table in descending order of the counter, move to the first and it tells me that the value is 11.
I can look at the table directly in Access and see the 12 records and, if I do the same read later, it sees the 12 records but when done immediately after the UPDATE, it only sees 11 records.
I know I could use Recordcount by the way but this gives the same wierd result.
I am very interested in what might be causing this and how to prevent it.
Thanks for ANY suggestions, David Abineri
I have occasion to add data to a table and then read the data back after the final UPDATE. Frequently I will not get all the data back if the read occurs right after the UPDATE and I am wondering why?
For example, I add 12 records to an empty small table (8 fields per record) which includes one field which is simply a counter to tell me the number of the record. I then open the table in descending order of the counter, move to the first and it tells me that the value is 11.
I can look at the table directly in Access and see the 12 records and, if I do the same read later, it sees the 12 records but when done immediately after the UPDATE, it only sees 11 records.
I know I could use Recordcount by the way but this gives the same wierd result.
I am very interested in what might be causing this and how to prevent it.
Thanks for ANY suggestions, David Abineri