Access 2010 Adapter Limitations

Supported Types

The types supported in this adapter are the following.

Data type	Field size	Type name	Support	Remarks
Text		VARCHAR	Limited
Memo		LONGCHAR	Limited
Numeric	Byte	BYTE	Limited
	Integer	SMALLINT	Yes
	Long integer	INTEGER	Yes
	Single precision floating point	REAL	Yes
	Double precision floating point	DOUBLE	Yes
	Replication ID	GUID	Limited
	Decimal	DECIMAL	Yes
Date/Time		DATETIME	Yes
Currency		CURRENCY	Yes
Auto number	Long integer	COUNTER	Yes
Auto number	Replication ID	GUID	Limited
Yes/No		BIT	Yes
OLE object		LONGBINARY	Yes
Hyperlink		LONGCHAR	Yes
Attachment		LONGCHAR	Limited	Retrieve the attached file name.

Related tables are not displayed in [Table relation information] of the table browser.

Replication ID type
- It cannot be read.
Text type
- The byte length is retrieved instead of string length.
Memo type
- When a multibyte character exists in a specific location, the data cannot be retrieved normally.
  For more details on the issues and the measures to avoid them, refer to “Method to get memo type data from an mdb file using ODBC API” in Microsoft Japan Support Team Blog (http://blogs.msdn.com/b/jpsql/archive/2011/09/26/odbc-api-mdb.aspx).
Attachment type
- When there is no attachment, empty string is retrieved.
When numeric type data is retrieved from the table that matches the following conditions, the correct data may not be retrieved.
- The first column of the table is text type and the field size is 9.
- Get data of text type column with field size 9 and numeric type column at the same time.
The table name is case-insensitive even if it is enclosed with quotation marks.

Replication ID type
- It cannot be read.
Text type
- The byte length is retrieved instead of string length.
Memo type
- When em-size character exists in a specific location, the data cannot be retrieved normally.
  For more details on the issues and the measures to avoid them, refer to “Method to get memo type data from an mdb file using ODBC API” in Microsoft Support Team Blog (http://blogs.msdn.com/b/jpsql/archive/2011/09/26/odbc-api-mdb.aspx).
Attachment type
- When there is no attachment, empty string is retrieved.
When numeric type data is retrieved from the table that matches the following conditions, the correct data may not be retrieved.
- The first column of the table is text type and the field size is 9.
- Get data of text type column with field size 9 and numeric type column at the same time.
SQL statement with Nz function cannot be executed.

Byte type
- When byte type is included in columns to write, batch update is not supported.
Attachment type
- It cannot be written to.
The table name is case-insensitive even if it is enclosed with quotation marks.

Byte type
- When byte type is included in columns to write, batch update is not supported.
Attachment type
- It cannot be written to.
SQL statement with Nz function cannot be executed.

Exception name		Cause	Solution
java.sql.SQLException	[Microsoft][ODBC Microsoft Access Driver] The table '<table name>' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.	The accdb or mdb file is used by another process.	Check the Access accdb or mdb file specified in ODBC database.
	[Microsoft][ODBC Microsoft Access Driver] The file '(unknown)’ is not found.	The accdb or mdb file is not found.	Check the Access accdb or the file specified in ODBC database.
	[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified	ODBC data source is not found.	Check [ODBC data source name] of the global resource.
	[Microsoft][ODBC Microsoft Access Driver] Input table or query '<table name>' is not found.	The table does not exist or the name is incorrect.	Check whether the table specified in [Table name] exists and the name is correct.