[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Data refresh

Posted on 2014-08-28
6
Medium Priority
?
202 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
0
Comment
Question by:DatabaseDek
  • 3
  • 3
6 Comments
 
LVL 40

Expert Comment

by:PatHartman
ID: 40291562
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
 

Author Comment

by:DatabaseDek
ID: 40292013
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
 
LVL 40

Expert Comment

by:PatHartman
ID: 40292645
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 

Author Comment

by:DatabaseDek
ID: 40293234
Will test Thank you.
0
 

Author Comment

by:DatabaseDek
ID: 40294226
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
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 40298743
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question