The supported OpenDB data types when using Microsoft Access are described below.
| Access Data Type | Supported by OpenDB | Comments |
|---|---|---|
| autonumber | Yes | For autonumber columns, OpenDB ignores the value used for the autonumber column unless it is an existing item, in which case the item is updated. Thus, to insert a new item the value for the autonumber column should be left empty (null) or a value that is known not to be an existing item should be used. |
| currency | Yes | |
| date/time | Yes | When entering data, use one of the following formats:
|
| hyperlink | Yes | Must start and end data for column with a number sign (#). For example: #C:\WINNT\mylink# |
| memo | Yes | Only the first 512 characters display. |
| number | Yes | |
| oleobject | No | Uses ODBC datatype sql_longvarbinary. |
| text | Yes | |
| yes/no | Yes | Use 1 for Yes, 0 for No. Any value other than 0 or 1 results in an error (RERR0018), which corresponds to the numeric value out of range. |