insert trigger

[GerryGoldberg]

I have written an insert trigger that simply takes the inserted data (from the inserted table and inserts into another table, e.g. tblHistory). This trigger seems to work fine when I insert target records using SQL 7 Server Enterprise Manager. I insert a row in the target table (tblTrans) and it appears in the tblHistory table.

However, when I try to do the same thing in Access 97 (no code involved--I just try to insert a row to my linked target table in datasheet view), I get a SQL error:
ODBC--Insert on linked table tblHistory failed
followed by a message:
Invalid object name 'mSysConf' (#208)

What am I doing wrong in Access? Any suggestions?

Thanks,

Gerry Goldberg

 

[GerryGoldberg]

Correction:

The first error that I get references tblTrans and not tblHistory. Also, I don't always get the second error.

Thanks,

Gerry Goldberg