ODBCTimeout Property [Excel 2007 Developer Reference]

MSDN Home

MSDN
MSDN Library
Office Development
2007 Microsoft Office System
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
Application Object
Properties

Properties

ActiveCell Property
ActiveChart Property
ActiveEncryptionSession Proper…
ActivePrinter Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
AddIns Property
AlertBeforeOverwriting Propert…
AltStartupPath Property
AlwaysUseClearType Property
AnswerWizard Property
Application Property
ArbitraryXMLSupportAvailable P…
AskToUpdateLinks Property
Assistance Property
Assistant Property
AutoCorrect Property
AutoFormatAsYouTypeReplaceHype…
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
Build Property
CalculateBeforeSave Property
Calculation Property
CalculationInterruptKey Proper…
CalculationState Property
CalculationVersion Property
Caller Property
CanPlaySounds Property
CanRecordSounds Property
Caption Property
CellDragAndDrop Property
Cells Property
Charts Property
ClipboardFormats Property
Columns Property
COMAddIns Property
CommandBars Property
CommandUnderlines Property
ConstrainNumeric Property
ControlCharacters Property
CopyObjectsWithCells Property
Creator Property
Cursor Property
CursorMovement Property
CustomListCount Property
CutCopyMode Property
DataEntryMode Property
DDEAppReturnCode Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultWebOptions Property
DeferAsyncQueries Property
Dialogs Property
DisplayAlerts Property
DisplayClipboardWindow Propert…
DisplayCommentIndicator Proper…
DisplayDocumentActionTaskPane …
DisplayDocumentInformationPane…
DisplayExcel4Menus Property
DisplayFormulaAutoComplete Pro…
DisplayFormulaBar Property
DisplayFullScreen Property
DisplayFunctionToolTips Proper…
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayScrollBars Property
DisplayStatusBar Property
EditDirectlyInCell Property
EnableAnimations Property
EnableAsyncQueriesInIdle Prope…
EnableAutoComplete Property
EnableCancelKey Property
EnableEvents Property
EnableLargeOperationAlert Prop…
EnableLivePreview Property
EnableSound Property
ErrorCheckingOptions Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExtendList Property
FeatureInstall Property
FileConverters Property
FileDialog Property
FileExportConverters Property
FileFind Property
FindFormat Property
FixedDecimal Property
FixedDecimalPlaces Property
FormulaBarHeight Property
GenerateGetPivotData Property
GenerateTableRefs Property
Height Property
Hinstance Property
Hwnd Property
IgnoreRemoteRequests Property
Interactive Property
International Property
Iteration Property
LanguageSettings Property
LargeOperationCellThousandCoun…
Left Property
LibraryPath Property
MailSession Property
MailSystem Property
MapPaperSize Property
MathCoprocessorAvailable Prope…
MaxChange Property
MaxIterations Property
MeasurementUnit Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Prope…
MultiThreadedCalculation Prope…
Name Property
Names Property
NetworkTemplatesPath Property
NewWorkbook Property
ODBCErrors Property
ODBCTimeout Property
OLEDBErrors Property
OnWindow Property
OperatingSystem Property
OrganizationName Property
Parent Property
Path Property
PathSeparator Property
PivotTableSelection Property
PreviousSelections Property
ProductCode Property
PromptForSummaryInfo Property
Range Property
Ready Property
RecentFiles Property
RecordRelative Property
ReferenceStyle Property
RegisteredFunctions Property
ReplaceFormat Property
RollZoom Property
Rows Property
RTD Property
ScreenUpdating Property
Selection Property
Sheets Property
SheetsInNewWorkbook Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowDevTools Property
ShowMenuFloaties Property
ShowSelectionFloaties Property
ShowStartupDialog Property
ShowToolTips Property
ShowWindowsInTaskbar Property
SmartTagRecognizers Property
Speech Property
SpellingOptions Property
StandardFont Property
StandardFontSize Property
StartupPath Property
StatusBar Property
TemplatesPath Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
Top Property
TransitionMenuKey Property
TransitionMenuKeyAction Proper…
TransitionNavigKeys Property
UsableHeight Property
UsableWidth Property
UsedObjects Property
UseLegacyKeyboardShortcuts Pro…
UserControl Property
UserLibraryPath Property
UserName Property
UseSystemSeparators Property
Value Property
VBE Property
Version Property
Visible Property
WarnOnFunctionNameConflict Pro…
Watches Property
Width Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
WorksheetFunction Property
Worksheets Property

Switch View :

ScriptFree

Application.ODBCTimeout Property

Returns or sets the ODBC query time limit, in seconds. The default value is 45 seconds. Read/write Long.

Syntax

expression.ODBCTimeout

expression A variable that represents an Application object.

Remarks

The value 0 (zero) indicates an indefinite time limit.

Example

This example sets the ODBC query time limit to 15 seconds.

Visual Basic for Applications
`Application.ODBCTimeout = 15`

See Also