Thread: ODBC/Windows and Rules

ODBC/Windows and Rules

From
"Joseph"
Date:
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