performance issue

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have an application which works fine on my machine, but it has performanace
issue on my user machine.

Our machines just sit side by side and connect to the same network.

Aything I need consider klike defragment HD?

Does Access have differnt process for different level ID like user ID who
has admin rights or not?
 
A cheap network card has caused me performance problems in the past. I fould
Intel NICs to be the best.
 
Thanks for the message,
I beleive that it is multi user.
I establish a permanant connection to server mdb then fix the performance.
Can I establish the connection using Excel spreadsheet?
I have Excel spreadsheet to talk to mdb database too.

It takes about 5 seconds to retrieve data from MS Access.
If I build a permanant connection with mdb database should have better
performance?

Your help is great appreciated,
 
You would need to test that scenario with your data to get a definitive
answer.

Theoretically, there are cases where you would get much better performance
from a normalized and correctly indexed database that you would from an
Excel list.
 
Back
Top