Solved

Set Up Options

Posted on 2014-04-09
3
195 Views
Last Modified: 2014-04-10
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
0
Comment
Question by:DatabaseDek
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39988866
<<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
 

Author Comment

by:DatabaseDek
ID: 39989040
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
 

Author Closing Comment

by:DatabaseDek
ID: 39992203
Thanks Jim
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now