Access ADP / SQL Server Trigger

[Gern Blandston]

Sorry for the cross-post. I posted this in the form/programming group
but didn't see the ADP group.

I'm working on an Access Data project against a SQL Server
2000 database. I have a form that contains a subform. The
subform has a View against a single table ("tblFactories")
for a Control Source.

tblFactories has an insert trigger
that writes out updated fields to an audit table
("tblAudit"). tblFactories has a primary key
called "FactoryID" which is an Identity Field.


When I insert a new record into the subform, I get the
following error:

"The Data was added to the database but the data won't be
displayed in the form because it doesn't satisfy the
criteria in the underlying record source"

I think I'm supposed to use the Resynch property, but I'm
not sure what it should look like. Any help would be
apprciated.

 

[Vadim Rapp]

GB> When I insert a new record into the subform, I get the
GB> following error:

GB> "The Data was added to the database but the data won't be
GB> displayed in the form because it doesn't satisfy the
GB> criteria in the underlying record source"

check out this error message in MSKB, especially

http://support.microsoft.com/default.aspx?scid=kb;en-us;213844


Vadim

 

[Gern Blandston]

check out this error message in MSKB, especially

http://support.microsoft.com/default.aspx?scid=kb;en-us;213844

Thanks for the link, Vadim. However, I'm not using 'WITH CHECK OPTION' in the view.

 

[Gern Blandston]

ADO will be confused, and look for the newly entered record using the identity
value of the record added to the table in the trigger, not the identity value of
the record ADO was trying to add.

Yeah, that's probably it. Thanks, Steve.