Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB6 and DAO Misreading Data?

Status
Not open for further replies.

dabineri

Programmer
Jun 20, 2001
265
US
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

 
Thanks for the response. I have come to believe that something like this was true. Do you have any 'official' references to this phenomenon, I'd love to find out more and how to get around it.

Thanks again, David Abineri

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top