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

    Unanswered: Of All the Forms...only one is extremely slow opening

    why would it be that only one form is slow opening? Every thing else opens, closes, does everything at a reasonable pace.

    There is no additional code that would be slowing it up, and all properties are similar to those of other forms...

    thanks to everyone that has been helping me...

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    And how much data is being pulled by this form????
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if there is no other explanation (big server-side .mdb, ugly query, ugly code) then it might be time to try the /decompile trick.

    pleeeeeeease make a backup before /decompile: there is a risk that your app will never work again after /decompile ...that backup might be the most important one you ever make.

    here for some info on /decompile.

    and there are several other discussions that google finds.

    i've used /decompile on several apps: file was always smaller; always worked fine afterwards; and maybe was a little faster (but wasn't that slow to start with so maybe this is imagination).

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Dec 2004
    Posts
    277
    should i do this on the front end application?

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    yes - decompile doesn't care about data.

    izy
    currently using SS 2008R2

  6. #6
    Join Date
    Dec 2004
    Posts
    277
    thanks for all the help

Posting Permissions

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