We help IT Professionals succeed at work.

Linked Table Slow

rvindust
rvindust asked
on
209 Views
Last Modified: 2010-03-19
I am connecting to SQL through OBDC from MSAccess.  I have approx. 50 machines that will be using the SQL. There are currently about 15 machines on SQL. about 25% of them run very fast. the other 75% run very slow.  All the odbc settings are the same, all the SQL drivers are the same. It seems to be computer oriented.  The same machines run fast no matter what scenario.  What network protocol should I be running and would this make a difference.
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.