SQL语句的check在ACCESS查询无法实现的问题

如果你打开查询，选择SQL视图，输入
CREATE TABLE stuTable(
sId CHAR(4) PRIMARY KEY, 
sName CHAR(20) NOT NULL,
sCredit int,
sPd int,
constraint Ccredit_name CHECK(Ccredit>0),
constraint Period_name CHECK(sPd>0));

一定会提示check约束子句中错误，只能在ADO+mdb的编程运行环境中下通过下面的语句来实现

Dim Cnn As New ADODB.Connection
ff = "CREATE TABLE stuTable(
sId CHAR(4) PRIMARY KEY, 
sName CHAR(20) NOT NULL,
sCredit int,
sPd int,
constraint Ccredit_name CHECK(Ccredit>0),
constraint Period_name CHECK(sPd>0))"
Cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mydata.MDB;Persist Security Info=False"
 Cnn.Execute (ff)