Hi all,
I am having a vexing problem using Firebird together with MSAccess.

I have a table Payments, which has these fields:
PaymentID (int, connected to generator PaymentID)
PaymentDate (date)
PaymentMethod (varchar)
SaleYear (int)
I can successfully link tables and add entries ot them in Access, using
the ODBC driver from:
http://www.firebirdsql.org/index.php?op=files&id=odbc
<http://www.firebirdsql.org/index.php?op=files&id=odbc>

I also created a view:
CREATE VIEW CAT_PAYMENTS AS
SELECT * FROM Payments
WHERE SaleYear = EXTRACT(YEAR FROM CAST('NOW' AS DATE))
WITH CHECK OPTION;

I would like to be able to use the view in Access so that a particular
user can only make entries for SaleYear being this year.

I can successfully insert items into the view using Marathon's SQL
execution function, and succesfully SELECT data from this view. I can
also successfully insert items into the view using a pass-thru query in
Access. However, when I attempt to use a regular query to add data to
this view, I get the error:
"Single-row update/delete affected more than one row of a linked table.
Unique index contains duplicate values."

Has anybody encountered this error or know anything about it? All I get
on the google newsgroups is stuff about checking for dupes, and I am not
violating any unique indexes.

To try to trace this problem, I would like to enable tracing in the ODBC
driver to figure out what SQL is sent to the server. However, there
don't appear to be any options in the driver dialog box for doing so.
Can anyone point me to resources on tracing ODBC calls?

Many thanks,

Eric