Results 1 to 4 of 4
  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!! (XP/XP vs 2K/2K)

    I have a multi boot machine - can boot to Win2K or Win XP. The Win2k machine has Office 2K, the XP machine has Office XP, both machines will all OS and Office updates. CPU = 700 Mhz;RAM=1gig; 3 x identical brand 80 gig drives, 1 dedicated to XP; 1 dedicated to 2K; 1 with shared data. Virtual memory in both cases managed by Windows ie no overrides by me
    I have an Access database using ODBC to access accounting data in MYOB (a popular accounting package in Australia - recently just bought out by Quickbooks in US and Canada).
    Before setting up the XP machine, I had gradually developed the database (using Office 2K on Windows 2K) with queries, reports etc and whilst it wasn't a speed demon, it went OK.
    Finally getting to the point - a particular make table query on the WinXP machine using Office XP - (Access 2000 file format ) takes over 8 hours to finish. Exactly the same query, using the same ODBC drivers and same Accounting file, takes just on 1 minute on the 2K/2K machine.
    ???
    Apologies if this is naughty but I will also post this to both the Access and XP forum
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SLOW!! (XP/XP vs 2K/2K)

    I've not seen any of this kind of behavior in the 18 months I've been working with both XP and 2000, but that doesn't mean it isn't possible. What Service Packs/Service Releases have you applied to each system?
    Wendell

  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!! (XP/XP vs 2K/2K)

    You may want to have a look at the following for the Microsoft Access Performance issues

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

    Please let us know what your solution was.

    HTH

    John

  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!! (XP/XP vs 2K/2K)

    Basically I'm being lazy (cause to check in detail requires a reboot ) but all service packs for XP/XP office and Win2k/Office2K have been applied. All antivrus/spyware removal is up to date and there is plenty of room on the hard drives (bound to be a question). In fact if anything the 2K machine should run marginally slower as there is less disk space available than on the XP machine
    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
  •