For more information about the option, see the Microsoft Jet Database Engine Programmer's Guide. The value of this option should not be changed without careful consideration of the consequences.
Microsoft access database drivers driver#
This value is initially set to "Yes", which means that the Microsoft Access driver will wait for commits in an internal/implicit transaction to be completed. 25 (Microsoft Access)ĭetermines whether the Microsoft Access driver will perform internal or implicit commits asynchronously. The path specification to the driver DLL.Īn integer ID for the driver. This sets the same option as Description in the setup dialog box. The path specification to the database file.Ī description of the data in the data source. This sets the same option as Database in the setup dialog box. When using the CREATE_V2DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples:ĬREATE_V2DB=C:\TEMP\test.mdb (no quotation marks needed) Therefore, creating a database and specifying a DSN is a two-step process. When using the CREATE_V2DB keyword in the same statement with a DSN keyword, this driver ignores the DSN keyword. If no sort order is specified, General is used. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. An error will be returned if the path name specifies an existing database.
Microsoft access database drivers full#
Has the following format: CREATE_V2DB=, where the path name is the full path to a Microsoft Access database. If no sort order is specified, General is used.Ĭreates a database file that is compatible with Microsoft Access 2.0. The sort order will be as set up in the New Database dialog box displayed when the Create button is clicked in the ODBC Microsoft Access Setup dialog box. Has the following format: CREATE_SYSDB=, where the path name is the full path to a Microsoft Access database. "C:\PROGRAM FILES\COMMON FILES\ MyAccess.mdb"ĬREATE_DB=C:\TEMP\test.mdb (no quotation marks needed)Ĭreates a system database file. Therefore, creating a database and specifying a DSN is a two-step process.When using the CREATE_DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples: When using the CREATE_DB keyword in the same statement with a DSN keyword, this driver ignores the DSN keyword.
Has the following format: CREATE_DB=, where the path name is the full path to a Microsoft Access database. Therefore, compacting a database and specifying a DSN is a two-step process.Ĭreates a database file. When using the COMPACT_DB keyword in the same statement with a DSN keyword, this driver ignores the DSN keyword.
Performs data compaction on a database file. This sets the same option as Collating Sequence in the setup dialog box. The sequence in which the fields are sorted. The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords. For general information about this function, see the appropriate topic under ODBC API Reference. This topic provides Access Driver-specific information.
0 kommentar(er)
