--- title: "SQLGetInfo (Access Driver) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual helpviewer_keywords: - "SQLGetInfo function [ODBC], Access Driver" - "Access driver [ODBC], SQLGetInfo" ms.assetid: c226aba7-a2f4-4b32-b640-92654b40e5a7 author: David-Engel ms.author: v-daenge --- # SQLGetInfo (Access Driver) > [!NOTE] > This topic provides Access Driver-specific information. For general information about this function, see the appropriate topic under [ODBC API Reference](../../odbc/reference/syntax/odbc-api-reference.md). **SQLGetInfo** supports the SQL_FILE_USAGE information type. The returned value is a 16-bit integer that indicates how the driver directly treats files in a data source: - SQL_FILE_NOT_SUPPORTED - The driver is not a single-tier driver. - SQL_FILE_TABLE - A single-tier driver treats files in a data source as tables. - SQL_FILE_QUALIFIER - A single-tier driver treats files in a data source as a qualifier. The ODBC driver returns SQL_FILE_QUALIFIER because each file is a complete database. ## SQL_BOOKMARK_PERSISTENCE SQL_BP_SCROLL | SQL_BP_UPDATE[1] [1] Bookmarks persist after a commit but do not persist after a rollback. ## SQL_CONVERT_BINARY SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_CHAR SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_DATE SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_DOUBLE SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_FLOAT SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_INTEGER SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_LONGVARBINARY SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_LONGVARCHAR SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_NUMERIC SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_REAL SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_SMALLINT SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_TIME SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_TIMESTAMP SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_TINYINT SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_VARBINARY SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_CONVERT_VARCHAR SQL_CVT_DOUBLE | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_NUMERIC | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR ## SQL_UNION SQL_U_UNION_ALL | SQL_U_UNION ## SQL_DBMS_VER |ISAM|Version|Format of version numbers| |----------|-------------|-------------------------------| |Microsoft Access|2.0|02.00.0000| ||3.0|03.00.0000| ||3.5|03.50.0000| ||4.0|04.00.0000| > [!NOTE] > Versions 1.0 and 1.1 are not supported. Also, there is no difference in the data format in Microsoft Access versions 3.0, 7.0, and 97. ## SQL_DDL_INDEX SQL_DL_CREATE_INDEX SQL_DL_DROP_INDEX ## SQL_GETDATA_EXTENSIONS SQL_GD_ANY_ORDER | SQL_GD_ANY_COLUMN | SQL_GD_BLOCK | SQL_GD_BOUND ## SQL_KEYWORDS ALPHANUMERIC AUTOINCREMENT BINARY BOOLEAN BYTE COUNTER CURRENCY DATABASE DATABASENAME DATETIME DISALLOW DISTINCTROW DOUBLEFLOAT FLOAT4 FLOAT8 GENERAL IEEEDOUBLE IEEESINGLE IGNORE IMAGE INTEGER1 INTEGER2 INTEGER4 LOGICAL LOGICAL1 LONG LONGBINARY LONGCHAR LONGTEXT MEMO MONEY NOTE NUMBER OLEOBJECT OWNERACCESS PARAMETERS PERCENT PIVOT SHORT SINGLE SINGLEFLOAT STDEV STDEVP STRING TABLEID TEXT TOP TRANSFORM UNSIGNEDBYTE VAR VARBINARY VARP YESNO ## SQL_NUMERIC_FUNCTIONS SQL_FN_NUM_ABS | SQL_FN_NUM_ATAN | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_EXP | SQL_FN_NUM_FLOOR | SQL_FN_NUM_LOG | SQL_FN_NUM_MOD | SQL_FN_NUM_POWER | SQL_FN_NUM_RAND | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN | SQL_FN_NUM_SQRT | SQL_FN_NUM_TAN ## SQL_OJ_CAPABILITIES SQL_OJ_LEFT SQL_OJ_RIGHT SQL_OJ_NOT_ORDERED SQL_OJ_INNER SQL_OJ_ALL_COMPARISON_OPS ## SQL_CATALOG_USAGE SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION | SQL_QU_INDEX_DEFINITION | SQL_QU_PROCEDURE_INVOCATION ## SQL_SCROLL_OPTIONS SQL_SO_FORWARD_ONLY | SQL_SO_STATIC | SQL_SO_KEYSET_DRIVEN ## SQL_STRING_FUNCTIONS SQL_FN_STR_ASCII | SQL_FN_STR_CHAR | SQL_FN_STR_CONCAT | SQL_FN_STR_LCASE | SQL_FN_STR_LEFT | SQL_FN_STR_LENGTH | SQL_FN_STR_LOCATE | SQL_FN_STR_LOCATE_2 SQL_FN_STR_LTRIM | SQL_FN_STR_RIGHT | SQL_FN_STR_RTRIM | SQL_FN_STR_SPACE | SQL_FN_STR_SUBSTRING | SQL_FN_STR_UCASE ## SQL_SUBQUERIES SQL_SQ_COMPARISON | SQL_SQ_EXISTS | SQL_SQ_IN | SQL_SQ_QUANTIFIED | SQL_SQ_CORRELATED_SUBQUERIES ## SQL_TIMEDATE_FUNCTIONS SQL_FN_TD_CURDATE | SQL_FN_TD_CURTIME | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_MONTH | SQL_FN_TD_NOW | SQL_FN_TD_SECOND | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR