解决access级联更新问题 - 其他数据库开发 / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ON UPDATE CASCADE)
发生约束错误

但是
CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)）可以运行

运行环境：sun.jdbc.odbc.JdbcOdbcDriver"

请高人指教~解决access级联更新问题

---

你的PC表中 model 是不是主键或索引？

---

String queryx="create table PC(model integer, speed integer, ram integer, hd integer, price integer,CONSTRAINT CHINA PRIMARY KEY (model))";
   
String query="CREATE TABLE Product(model integer, maker varchar(20), CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) ON DELETE CASCADE ON UPDATE CASCADE)";
   
  s.executeUpdate(queryx);
  s.executeUpdate(query);


问题在于ON DELETE CASCADE ON UPDATE CASCADE。好像不能这样写~谁有经验解决一下~

s具体内容省略..

---

你是通过ODBC连接MDB的？