Microsoft Access Database Field Support

Attachment field type

Iron Speed Designer does not support the Attachment field type because they cannot be read or written using ADO.NET.

Currency and Number data type mapping

Two of the data types supported by Microsoft Access are Currency and Number.  The Number data type allows you select a Field Size which can be a Byte, an Integer, a Long Integer, a Decimal, etc.  The Currency data type does not allow you to select a Field Size.

Both Currency and Number allow you to select a display format in Microsoft Access.  One of the possible display formats is called Currency, which can be confused with the Currency data type.  For example, you can have a Number/Byte field with a Currency display format, and you can also have a Currency field with a Currency display format.

When initially reading your database, Iron Speed Designer sets the Iron Speed field validation types based on the Microsoft Access data type and not based on display format.

Currency field custom display formats in Microsoft Access 2007 and 2010

Iron Speed Designer does not use the custom display formats in the currency fields of ACCDB files.  Iron Speed Designer sets the display format to the application’s default display format.

Hyperlink field limitations

Hyperlink fields are supported.  However, they are displayed and used as static values without hyperlink display.

Memo fields marked as ‘AppendOnly’

Because Iron Speed Designer does not support AppendOnly fields, it treats them as read-only.  Additionally, if an AppendOnly field is specified as required (i.e. NOT NULL) then the entire table is set to read-only.

Multi-valued fields

Because Iron Speed Designer does not support multi-value data entry, it treats multi-valued fields as read-only.  Additionally, if a multi-valued field is specified as required (i.e. NOT NULL) then the entire table is set to read-only.

Foreign keys that support multiple values are not supported.  These are typically defined in Access as Lookup fields that reference a Table/Query.  Example:

Iron Speed Designer ignores foreign keys defined in this way, although the foreign key fields themselves are recognized and marked as read-only.  The data type on these fields will show as “Memo” in the database area.

See Also

Microsoft Access Support

Microsoft Access 2000 Versions

Microsoft Access Database Field Support

Query Support in Microsoft Access

Linked Databases in Microsoft Access

Relative and Absolute Path Names for Microsoft Access Databases

Accessing Microsoft SQL Server Tables through Microsoft Access Queries