We help IT Professionals succeed at work.

Data refresh

Derek Brown
Derek Brown asked
on
214 Views
Last Modified: 2014-09-05
What setting would you suggest is ideal for ODBC refresh interval.

I have an app that works on three machines but will not connect to the data on the server with the 4th.

Works great with the data on the local drive?

It tries to connect and just hangs there.  I wondered is a 3 minute refresh ODBC was inaprpriate

Update retry is set to 250 msecs
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
I think we need to know more about the data source.  What is it and is it located on your LAN or are you trying to connect over the internet?

Author

Commented:
Hi

This is just a regular internal server connecting directly with each PC over a LAN. Data source is Access .mdb file just split from the main program
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
If the data source is Jet, you are not using ODBC and so changing the refresh interval will not do anything.

Access allows up to 255 concurrent connections to a database so 4 should not present a problem.  I would look at the permissions for the fourth user to make sure that he has CRUD permission on the folder containing the BE.

Author

Commented:
Will test Thank you.

Author

Commented:
I have passed this info to the IT department of the customer.

For future reference what are CRUD permissions by the way and how do you find out?
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*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.