Results 1 to 1 of 1
2003-11-16, 05:06 #1
- Join Date
- Jan 2001
- Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
- Thanked 0 Times in 0 Posts
XP vs Win2K (Access2k&XP Windows 2k&XP)
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.
Apoligies if this is naughty but I will also post this to both the Access and XP forum
no cross-posting here <!rule=14>Rule 14<!/rule>, please answer <post#=313112>post 313112</post#> insteadDummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>