access97 slow on Windows2000 Server

C

ChaimG

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 W2K Server and W98 Client, or on XP local Drive, or
on XP with Novell.
Does anyone know why?

Any help gratefully received.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries that run in 1 second take minutes on another server? 6
db.execute INSERT INTO very slow 4
New Server - slow MS Access 0
this code is VERY slow, is it the code or perhaps a worksheet issue 32
Access slow saving a report to mdb on a netware server 1
Access really slow over the network 6
Slow form, again 28
Strange problem 0

Top