Data refresh

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
Derek BrownMDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
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?
0
Derek BrownMDAuthor 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
0
PatHartmanCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Derek BrownMDAuthor Commented:
Will test Thank you.
0
Derek BrownMDAuthor 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?
0
PatHartmanCommented:
Create, Read, Update, Delete.  These are DOS file permissions and are set by your network support group for shared folders on network drives.

Read and Update are obvious.  Without them being set, the user would not be able to view or change data.
Create and Delete are needed because of the way Access manages the sharing of a database.  When a database is opened by the first person, Access creates a lock file - hence the need for Create permissions.  If Access cannot create the lock file in the directory of the BE, it will still open the database but it will open it in exclusive mode so that others cannot share it.  They will be forced to open as read only.  The Delete permission is needed so that when the last person closes the database, Access can clean up after itself and delete the lock file.

You can watch the lock file being opened and closed by opening a windows folder and keeping it visible while you open the database.  You'll see the lock file being created when you open the database and then deleted when you close it.  These are typically the problem settings because unless your network admin understands how Access works, he may not automatically assign these permissions to your user group.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.