OleDbDataReader - reading order

[Islorvat]

Hi guys, I've searched google but didn't find anything regarding this issue. I'm updating an MS Access table after reading some fields from the same table. While doing this i have a label to check how many rows have been processed out of total and i see that the reader jumps from an ID to another, process a few rows then comes back to the ID before jump happened. Is this thing normal? The table is created from an imported text file using Access.Application.DoCmd.TransferText. I thought compacting the database after import will fix this, but didn't. Any ideas? Thank you!

[Luc Pattyn]

IMO a database is not supposed to obey a specific order, unless you specify one. Ultimately if you don't specify an order, the results could be different each time. I always specify an order before the user gets to see the data, so he shouldn't get any surprises here. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Please use <PRE> tags for code snippets, they improve readability.
CP Vanity has been updated to V2.3

[Islorvat]

It just didn't cross my mind to order by ID. :) Thanks!

[Luc Pattyn]

You're welcome. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Please use <PRE> tags for code snippets, they improve readability.
CP Vanity has been updated to V2.3