Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Viet Nam
    Posts
    2

    Unanswered: Fast search on MS Access

    I have project with MS Access but when I search record on it speed more time ( very slow but I created index for primary key) so I want fast search ! My database about 100.000 record !

    Can anyone Help me ! Thanks alot

  2. #2
    Join Date
    Jan 2003
    Location
    Pittsburgh, PA
    Posts
    86

    Re: Fast search on MS Access

    Is your search on the Primary Key? Or are you searching on another field in the table? If so, then you want to create an index on that field also (allow for duplicate values, if necessary).

Posting Permissions

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