Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SLOW!! (Access XP, Winsows xp SP1)

    XP group suggested I try here
    Finally bit the bullet and moved from 2000 to XP(clean install). In the process I upgraded the RAM to 1G (from 512m). Having now re-installed all my software, I got to run a real application today and am horrified at the speed
    Application is an Access file using ODBC to get data from an accounting file. Large and unwieldy, so I am used to some actions taking up to 30 minutes. I have now been running this for 5 hours and it is halfway through. Both the MYOB (accounting file) and the Access file (which uses ODBC to access MYOB) are stored locally on the primary hardrive
    Changes since 2000:
    Increased RAM to 1Gig ( but no appreciable change in speed when I subsequetly removed second RAM stick and went back to 512 meg)
    Installed Office XP as replacement from Office 2000
    Task Manager shows only about 200meg ram being used - no improvement if I set priority to either High or real time. Paging file is set to System managed size and is currently 1535 MB - 2 drives each partitioned into primary of 30 Gig and balance for data - second drive is intended to be used for Ghosting C and backing up data from D
    CPU usage is not too bad: varies from 6 to 18% with some spikes to 20%
    Disk is 7,500 rpm (or whatever the standard number is near that)
    Disk is 80 Gig, 30 partitioned for XP and 17gig of that is free space and was only formatted last week to install XP and has been defragged
    HELP Please!!
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  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!! (Access XP, Winsows xp SP1)

    What version of Access were you using before? There are a few speed sappers in 2000 and 2002, but without knowing more about what has changed in your system, there's no point in making suggestions that may not apply. Are you using the Access 2000 or 2002 file format?
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SLOW!! (Access XP, Winsows xp SP1)

    Hi Steve

    You can check the following link for possible perforance issues:

    http://www.granite.ab.ca/access/performancefaq.htm

    HTH

    John

    PS: Keep us updated on your progress to acceptable performance

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SLOW!! (Access XP, Winsows xp SP1)

    Sorry I wasnt as clear as I hoped
    Was using Acess 200 now using Access XP but file opens in Access 2000 file format. No longer have Access 97 and Access 2000 on this machine (did under Win2k)
    Changes to machine:
    Clean install of XP after full format - everything else same as Win2k machine
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SLOW!! (Access XP, Winsows xp SP1)

    Thanks for the suggestion - I'll work my way through the site and report back on anything that works
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

Posting Permissions

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