Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Red face Unanswered: Recordset not sorting using the primary key

    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?

  2. #2
    Join Date
    Mar 2003
    Posts
    4

    Wink

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •