Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: MS Access & MS SQL Server: long time answers

    I use MS ACCESS and tables linked to MS SQL SERVER tables.
    There are indexes defined (they are visible in MS ACCESS too).
    Sometimes DLOOKUP functions are taking long time.
    Why?

  2. #2
    Join Date
    Jan 2004
    Location
    Hungary, Europe
    Posts
    4

    Re: MS Access & MS SQL Server: long time answers

    Do you use odbc linked tables or is this a project which mssql backend ?

    If you use linked tables, and have lots of rows, this can be "normal".
    As I experienced (this is only my opinion, i can't prove it) sometimes access grabs all the data from sql, somehow ignoring the WHERE clause, and does a filtering on a client side.

    If you use access project and stored procedures/views, it's caused by badly defined indexes. If you have full mssql server, the "Index tuning wizard" can help in the Query Analyzer to set up the right indexes.

Posting Permissions

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