By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

access97 slow on windows2000 Server

P: n/a
Hi everyone,

I Run DB Application using Access97 (with DAO) on XP Client and
Windows2000 Server (Version5, SP4) with active directory.
A Simple "Select *" Query takes no time ( less then second), but query
with "Group By " Expresion ( Select CustNum From Customers Group By
CustNum) takes more then 30 seconds to perform.
This Problem accures only with XP Client on Windows2000 server.
The same "Group By " Querys takes less then second On the same W2000
Server and W98 Client, or on XP local Drive, or on XP with Novell.
Does anyone know why?

Any help gratefully received.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Tony Toews has a good page at:
http://www.granite.ab.ca/accsmstr.htm
describing the performance issues you are struggling with, and how to
resolve them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"ChaimG" <de*****@tamal.co.il> wrote in message
news:58**************************@posting.google.c om...
I Run DB Application using Access97 (with DAO) on XP Client and
Windows2000 Server (Version5, SP4) with active directory.
A Simple "Select *" Query takes no time ( less then second), but query
with "Group By " Expresion ( Select CustNum From Customers Group By
CustNum) takes more then 30 seconds to perform.
This Problem accures only with XP Client on Windows2000 server.
The same "Group By " Querys takes less then second On the same W2000
Server and W98 Client, or on XP local Drive, or on XP with Novell.
Does anyone know why?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.