Results 1 to 2 of 2

Thread: Mr

  1. #1
    Join Date
    Mar 2013

    Unanswered: Mr

    l have inherited aa access Frontend (2010 & 2003) running on a Sql Backend.

    The system is currently extremly slow. Can l get expert advise on how to enhance performance. l am new to this concept.
    1 what are the possible areas to check to isolate the problem.

    2. A colleague is advice to activate ODBC connection. How do l check if the system is running on Odbc and how do l activate odbc on both the 2003 & 2010 Frontends.

    3. what is Dsn connection as against ODBC connection.

    4.Another Suggestion is to write stored procedures. Do l have to ammend querries at the client end when stored procedures or Odbc are activated.
    If so what sort of ammendments should l have to make.

    l will appreciate some assistance with how best to deal with above issues.

    4. Finally can you suggest any Materials/books that can help .

    Many Thanks


  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Make sure your database tables are properly indexed, and then try to push as much processing back onto the server as possible.
    When MS Access has to process a query locally, it first has to transfer all the data for all referenced tables over the network. A query processed on the server merely needs to return the answer over the network.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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