Results 1 to 2 of 2

Thread: search

  1. #1
    Join Date
    Apr 2004

    Unanswered: search

    I work with an access db with up of 90000 records. Just now I have problem with
    this db:
    1. I use this db on network with "back_end & front_end" option, and connection
    to db takes about 10 minutes on lan network with 10Mbps
    2. The search on memo field takes up of 15 minutes. I do the search by "like
    expression". For example: select * from news where news.text like "*report*"
    Is there any way to speed up the access db. I usually do "compact and repair" on
    this db.
    Thanks a lot

  2. #2
    Join Date
    Jun 2004

    Access ???

    How are Access and Adabas related ?????

Posting Permissions

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