Does it take something special to make rules with the odbc connection?
I am using MS Access 97 and things work good until I make a rule.
If I try to link to a table with rules the error is "Invalid definition
'oid' in definition of index or relationship."
What does this mean?
When I add a rule to a table after I have it linked I can not do any new
inserts.
Here is the rule:
create rule tbl_clarify_insert_rule as on insert to foocl where
new.itemcode in (select itemcode from tbl_clarifymonitor) do select
mail('joes@clp.org','Security','Subject','Body','');
Joseph Showalter