Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Slow Network? (Access 2002)

    Hi

    We recently upgraded servers and software at our office. We moved from a Windows NT and Access 97 environment to a Windows XP and Access 2002 environment. Since then a number of the upgraded Access DBs (97 to 2002) are running very slowly. Both BEs and FEs have been upgraded, compacted and links refreshed.

    I think the issue relates to the network as opening the table in the BE is very fast, yet opening the linked table in the FE is very slow. This slowness is magnified when using forms. Also none of the DBs have huge amounts of data.

    Is there anything else I can do to check whether it is an Access issue, rather than a network issue. If the latter, would anyone have any suggestions on the causes or what I should raise with our IT people.

    Many thanks

    Regards
    WTH

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

    Re: Slow Network? (Access 2002)

    Two things to check in Access:

    1) Make sure Name AutoCorrect is turned off in the front and back end, and

    2) Make sure that subdatasheets are set to [None] on all the tables, front and back end. This includes the linked tables.

    After you've done those things (there is code in the helpfile for turning off subdatasheets), test it and see whether the situation has improved. I would suspect the subdatasheets based on your description, since I've seen the same behavior for that reason. Another issue arises if your forms use select strings instead of saved queries as their data source. A saved query is optimized and stays that way. A select string is optimized the first time you open the form in each session. The initial delay can be significant if there is a large number of records in the returned recordset.
    Charlotte

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

    Re: Slow Network? (Access 2002)

    What happens if you put a copy of the Front End and Back End on a local hard disk and relink the tables in the FE to those in the local BE?

    BTW, have you turned off the Track Name AutoCorrect options in the General tab of Tools | Options... (this is a per database setting.) And have you turned off subdatasheets for all tables?

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slow Network? (Access 2002)

    Hi Guys

    Many thanks for the suggestions.

    The suggestion to try the DB on C: drive was enlightening. There was no speed issues, and that's even before trying the other suggestions about turning off autocorrect and subdatasheets. It also ran slightly quicker when using the FE on the network and BE on the C: drive. So my conclusion is the network is running slow. If that's the case, what, if anything, can I do to improve network performance?

    Regards
    WTH

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

    Re: Slow Network? (Access 2002)

    I'm not a network expert, but here are some things you might do/test:
    <UL><LI>Create a persistent connection from the FE to the BE by keeping a form bound to a table in the BE open during the entire session, or by opening a recordset on a table in the BE when the database is opened, and keep it open until the database is closed. This prevents the .LDB file from being manipulated all the time.
    <LI>Keep the full path name of the BE as short as possible, by a) creating a share for the folder the BE is in, so that it seems the BE is in the root, and [img]/forums/images/smilies/cool.gif[/img] giving the BE a short name.
    <LI>If the anti virus software scans network files, try turning this off for a test.
    <LI>Avoid user-defined functions in queries where possible.[/list]And of course, you might test, or have somebody test, general network performance (not just Access.)

  6. #6
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slow Network? (Access 2002)

    Hi Hans

    Thanks for the tips.

    I'll try give them a go and then discuss the matter with our IT people.

    Regards
    WTH

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Slow Network? (Access 2002)

    One other item to check. The last time our IT guys updated our network, they removed one of the routers and caused a really bad bottleneck. Of course, they didn't admit to this until pressed. They said with the upgrage the additional router was not needed because the network would be much faster, but that was not the case. Once the additional router was re-installed, the speed returned to normal.

    I'm with Hans on the virus protection as this has caused major speed issues here, even worse if a virus gets through.
    Regards,

    Gary
    (It's been a while!)

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slow Network? (Access 2002)

    <font color=red>They said with the upgrage the additional router was not needed because the network would be much faster</font color=red> Either they really believed that or it was a way of staying within an overall budget! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Gre

Posting Permissions

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