Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Unanswered: Open Recordset with Max 100 records

    I am opening a recordset in code but as there are alot of records it is slow. Can I limit the number of records retrieved in a recordset ?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select top 100 *
    from tableA

    Thank You.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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