I am using a SQL server back-end with a MS-Access Project front end.
I have created a data-access page that looks at an table called "tblamendment" to go on our Intranet.
Unfortunatly I have an instead of insert trigger on the "tblamendment" table, and each time I try to save the record an the data-access page I get an error saying "a certain" field cannot contain a null value.
Thats all fine and good but the Instead Of Insert Trigger has taken care of all the fields that cannot have a null value. Just to prove this futher I did a mannual insert into the table from SQL just puting in values for the fields that the Data Access pages populates this worked no problem, thanks to the instead of insert trigger.
So is there something wrong with Data-Access-Pages that makes it skip my Instead Of triggers.
I have posted this on quite a lot of forums and had no reply what so ever, so either I am not explaining myself very well (which is most likely) or no one can help me ????????????