Edit

Share via

DriverPromptEnum enumeration (DAO)

  • Article

Applies to: Access 2013, Office 2013

Specifies if and when to prompt the user to establish a connection.

Name

Value

Description

dbDriverComplete

0

If the connection string provided includes the DSN keyword, the driver manager uses the string as provided in connect, otherwise it behaves as it does when dbDriverPrompt is specified.

dbDriverCompleteRequired

3

(Default) Behaves like dbDriverComplete except the driver disables the controls for any information not required to complete the connection.

dbDriverNoPrompt

1

The driver manager uses the connection string provided in connect. If sufficient information is not provided, a trappable error is returned.

dbDriverPrompt

2

The driver manager displays the ODBC Data Sources dialog box. The connection string used to establish the connection is constructed from the data source name (DSN) selected and completed by the user via the dialog boxes.