Defining Refresh Interval and ODBC Refresh Interval for users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CASDHackerMan - 11 Jan 2006 18:12 GMT

Hello,

We are trying to find out where the settings for Refresh Interval and ODBC
Refresh Interval are stored because we are considering setting this for each
user because they have a tendency to keep queries in Access open which call
on linked tables from SQL Server, and when they keep the queries open, it is
locking the SQL Server tables. We found from some analysis in SQL Server
itself that the locking is happening every time the Access query hits its
interval. So we want to increase this value so high so that the queries will
only lock the table for the split second upon the initial opening and that's
all. If the users want to refresh they will just have to manually do so.

Does anyone know where the Refresh Interval settings live? Is it in the
Registry or is it in a file someplace? Your help is appreciated.

Thank you.

Reply to this Message

WyattR - 03 Feb 2006 11:27 GMT

The setting you are looking for can be found in Tools, Options, Advanced Tab.
The setting is "ODBC refresh interval". It is in the left column near the
bottom. You must have the database open to get into Options.

> Hello,
>
[quoted text clipped - 12 lines]
>
> Thank you.

Reply to this Message

CASDHackerMan - 03 Feb 2006 13:29 GMT

I knew that, but where is this setting saved to? Is it saved to a file or is
it saved to the registry? I am trying to find where it lives because we want
to see if this setting can be "globalized" either via a file or registry
script to a group of users.

> The setting you are looking for can be found in Tools, Options, Advanced Tab.
> The setting is "ODBC refresh interval". It is in the left column near the
[quoted text clipped - 16 lines]
> >
> > Thank you.

Reply to this Message