Slow DAO Query in Windows 7 RRS feed

  • Question

  • Hello,

    We use DAO 3.5 and we are seeing delays on some queries on windows machines 7.
    The database is on a windows server 2008.
    The query is a join between two tables and contains an ORDER BY.

    The query execution is very slow.
    If we remove the join or order by the query execution is fast.

    Is there an incompatibility between Windows 7 and DAO 3.5 ?

    Thank you for your ideas and suggestions


    Tuesday, October 5, 2010 4:15 PM


  • Any possibility it's network related?

    DAO 3.5 is even more dated than 3.6. I'm surprised you aren't using at least 3.6. Are you working with Visual Basic .NET or another version of Visual Basic?

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by Martin_Xie Tuesday, November 2, 2010 1:15 PM
    Tuesday, October 5, 2010 5:07 PM