Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: Access is lagging...anything I can do?

    Access seems to be lagging in between processes... is there anything I can do....

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Try running a compact & repair ... What processes?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    compact & repair only does so much.. it lags when you try to run a query or flippin from form to form...

    is there any type of code i can put into Form_Load or something?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Possibly part of your performance issue may be how many records you're trying to retrieve and how your queries retrieve them ... Are your queries constructed to retrieve data based on keys?
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Dec 2004
    Posts
    277
    it definitely is not pulling a lot of information...considering that i only have 10 records in the program as of now

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Ok ... Then what do you mean by lag? What kind of performance are you looking for?
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Dec 2004
    Posts
    277
    going form to form.... it doesn't just go the one form closes... waits a second... then opens the form...

    it is not the computer and the equipment there is plenty of ram, Cpu speed...

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DackJaniels
    going form to form.... it doesn't just go the one form closes... waits a second... then opens the form...
    What do you mean? Are you opening and closing forms?
    Back to Access ... ADO is not the way to go for speed ...

  9. #9
    Join Date
    Dec 2004
    Posts
    277
    yes one form is open, closes and opens another form

  10. #10
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    That's just the Access overhead ... About the only way to combat it is to have the form opened and hidden then it's a call to it to unhide ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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