> Hi Alan,
> Thanks for going over my queries and table definitions.
> I'm guessing that the problem with Access inserts is due to SQL
> incompatibilities between Access' Jet SQL and Firebird's dialect 3, or
> an incompatibility/bug in the ODBC driver relating to inserting
> into views.
>
> Do you or anyone else know any good ways of tracing what SQL Access/ODBC
> actually passes to Firebird?
>
> Thanks,
>
> Eric
>

If you use a System DSN for the ODBC connection and not a DSN-less
connection, then the ODBC Manager provides for tracing of any/all drivers.
Alan