Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Slow response times, since conversion (2000)

    We have a database (not mine) that has been converted from Access95 to 2000, the Microsoft DAO 3.6 references have been enabled and moved to the top of the references list.

    But ever since the conversion, one of the forms takes a long time to load. (~Over 3 minutes).. Even if you just hit design' you will wait the same time.

    The form itself is a fairly complicated one, and has a fair bit of code behind it.


    Anyone know why this particular form should take so long. anything that i can check.. or is this normal ?

    From memory, it never used to take this long under Access95, it used to be instant, just like all the other forms.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Slow response times, since conversion (2000)

    Hello Steve,

    There are a few things that you can check:
    <UL><LI>Open the database, then select Tools | Options... Activate the General tab. Make sure that the Name AutoCorrect options are off (check boxes cleared). Name AutoCorrect is a new feature in Access 2000 that causes a lot of problems.
    <LI>(Probably less relevant, but anyway) Open each table in the database in design view, and set the Subdatasheet Name property to [None]. Close and save the table.[/list]And last but not least, compact the database regularly (Tools | Database Utilities | Compact and Repair.) If you like, you can check 'Compact on Close' in the General tab of Tools | Options...

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Slow response times, since conversion (2000)

    In addition to Hans suggestions, take a close look at the form to see what it's doing. If you are setting the recordsource of the form in code, there will be a delay the first time you open the form in a session. The query engine that processes the SQL can't optimize a SELECT statement as the recordsource in advance, so it does it on the fly. If the form opens slowly the first time and quickly after that in the same session, then optimization is the issue.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slow response times, since conversion (2000)

    Hans.. as usual you come up with the goods.

    The first option, just unchecking those 2 boxes, made the form open in 13 seconds, instead of 3 minutes 20+..


    Now... I know what you think about the subject, so i won't rant toooo much...... but

    /rant on <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>

    F&*%

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Slow response times, since conversion (2000)

    Hi Steve,

    The people who develop Office come up with a lot of brilliant things, so I wouldn't call them idiots, but it is amazing how often they choose a default setting that nobody wants, or should want.

Posting Permissions

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