Access 2013 Adapter Limitations

• Supported Types
• Limitations Common to All Operations
• Read Table
• Execute Select SQL
• Write Table
• Execute Update SQL
• Major Exceptions

Supported Types

• Yes: Supported.
• Limited: Supported with limitations.
• No: Not supported.

Limitations Common to All Operations

Specification Limits

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


• Table with a name including “{” and “}” (curly braces) cannot be used.

Notes

• Locking Access file
  When Access adapter is configured or executed, a laccdb or ldb file (lock file) is created to get data from Access.
  The timing to generate and discard the lock file is as follows.
  • Generate: Select the global resource in adapter properties or open the properties window of adapter where the global resource is set
    Discard: Close the project
  • Generate: Execute the script from Designer
    Discard: When the execution ends
  • Generate: Execute the service from an external tool (such as Trigger or ScriptRunner)
    Discard: When the execution ends

Read Table

Specification Limits

• 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.

Execute Select SQL

Specification Limits

• 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.

Notes

• There is some unavailable functions due to Access specifications.
  Refer to “Turn sandbox mode on or off to disable macros” in Office support (http://office.microsoft.com/en-us/access-help/turn-sandbox-mode-on-or-off-to-disable-macros-HA102749579.aspx) for more details.

Write Table

Specification Limits

• 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.

Execute Update SQL

Specification Limits

• Byte type
  • When byte type is included in columns to write, batch update is not supported.
• Attachment type
  • It cannot be written to.

Notes

• There is some unavailable functions due to Access specifications.
  Refer to “Turn sandbox mode on or off to disable macros” in Office support (http://office.microsoft.com/en-us/access-help/turn-sandbox-mode-on-or-off-to-disable-macros-HA102749579.aspx) for more details.

Major Exceptions