Set Up Options

In Avanced Options What is:
OLE/DDE/ timeout  30
Refresh interval  60
Number of update retries 2
ODCB Refresh interval (sec) 1500
Update retry interval 250

and how should they be set

I have a few problems with an app that has the data on a server.

I cannot use the help file as it will not work with Access 2002 on windows 8.1
Derek BrownMDAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
<<OLE/DDE/ timeout  30>>

This is the timeout for communicating with other applications via OLE (Object Linking and Embedding) or DDE (Dynamic Data Exchange, the forerunner to OLE).

<<Refresh interval  60>>

  How often a form should refresh it's records.

<<Number of update retries 2>>

 How many times JET should attempt to retry a save operation when it's blocked.

<<ODCB Refresh interval (sec) 1500>>

  How often ODBC data should be refreshed.

<<Update retry interval 250>>

  In milliseconds, how quickly it should retry.

In general, the defaults are adequate unless you have some specific situation and a problem as a result.

Jim.
0
 
Derek BrownMDAuthor Commented:
Will any of these settings cause an access application to start showing errors such as opening a form and no subform data is available. I think that some tables on the server are just not coming through at all or quick enough. So the link does not seem to be made to the data.

I have exactly the same program working on other servers without any sign of a problem

(Should this be another question?)
0
 
Derek BrownMDAuthor Commented:
Thanks Jim
0
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.

All Courses

From novice to tech pro — start learning today.