Microsoft Access Database Tables, Views and Procedures support

Views and Procedures

Iron Speed Designer Does support Views defined as set of fields from one or more tables with joining queries. Procedures defined in Microsoft Access are not supported.  Any foreign keys that reference Procedure are ignored. If you define function in a query, such as Nz (if Null then zero), your View becomes a Procedure and Microsoft's OleDB data provider for .NET no longer returns the view as a view, but rather as a Procedure.  In such case there is no way to retrieve proper information about this function and schema is not created. Such Views are ignored

Union query

Union queries defined in Microsoft Access are not yet supported.  Any foreign keys that reference union queries are ignored.