I am using ODBC connection (with DSN) from Access2000 to
SQLServer2000.
I have experience Unstable Performance: I checked the same
query twice once it run in 3 sec and after a few houres at
25 sec'. when I refresh the attached tables (By code), the
performance returned to 3 sec.
I also experience once in a while an ODBC connection fail.
I try to use Name Pipes and TCP-IP but I have the same
problems.
Can any body help?
Thanks,
Nitzan