Defining Refresh Interval and ODBC Refresh Interval for users

[CASDHackerMan]

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.

 

[WyattR]

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.

 

[CASDHackerMan]

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.