Hi all.

I'm using Microsoft.Jet.OLEDB.4.0 & ADO recordsets to manipulate and query an Access database but when I populate the recordset with a simple "SELECT * FROM tableName" the records are in no particular order. ADO seems to be ignoring the Primary key on the tables in Access

1. Can anybody tell me why the Index (key) is ignored?
2. How can I remedy this?
3. I know I can use "ORDER BY" to rearrange the records but surely that is extra work for the CPU and will degrade performance?

DOH!
Forgot to mention that I'm doing this through Visual basic.