如何在ACCESS2000执行powerdesigner生成的脚本？

[cqjiang]

我的脚本如下：
#==============================================================
# Database name: MixDB
# DBMS name: Microsoft Access 2000
# Created on: 2004-3-29 18:18:54
#==============================================================


RemoveJoin C=FK_FORMULA_REFERENCE_FORMULAN T=FORMULA P=FORMULANAME;

RemoveJoin C=FK_FORMULA_REFERENCE_MIX_BIN T=FORMULA P=MIX_BIN;

RemoveJoin C=FK_PRODUCE_REFERENCE_FORMULAN T=PRODUCE P=FORMULANAME;

RemoveTble C=FORMULA;

RemoveTble C=FORMULANAME;

RemoveTble C=MIX_BALANCE;

RemoveTble C=MIX_BIN;

RemoveTble C=PRODUCE;

#==============================================================
# Table: FORMULA
#==============================================================
CreateTble C=FORMULA N="FORMULA(配方表)"
(
C=NAMEID T=INT P=Yes M=Yes N="NAMEID",
C=BINID T=INT P=Yes M=Yes N="BINID",
C=WEIGHT T=DOUBLE P=No M=Yes N="WEIGHT" D=100
);

addtbllabl T=FORMULA L="配方定义表";

addcollabl T=FORMULA C=NAMEID L="配方名ID";

addcollabl T=FORMULA C=BINID L="料仓ID";

addcollabl T=FORMULA C=WEIGHT L="重量";

#==============================================================
# Table: FORMULANAME
#==============================================================
CreateTble C=FORMULANAME N="FORMULANAME(配方名)"
(
C=ID T=INT P=Yes M=Yes N="ID",
C=NAME T=VARCHAR(32) P=No M=Yes N="NAME",
C=AUTHOR T=VARCHAR(12) P=No M=No N="AUTHOR",
C=MODIFYDATE T=DATE P=No M=Yes N="MODIFYDATE",
C=CREATEDATE T=DATE P=No M=Yes N="CREATEDATE",
C=NOTE T=VARCHAR(256) P=No M=No N="NOTE"
);

addtbllabl T=FORMULANAME L="配方表";

addcollabl T=FORMULANAME C=ID L="配方编号";

addcollabl T=FORMULANAME C=NAME L="配方名称";

addcollabl T=FORMULANAME C=AUTHOR L="作者";

addcollabl T=FORMULANAME C=MODIFYDATE L="修改日期";

addcollabl T=FORMULANAME C=CREATEDATE L="创建日期";

addcollabl T=FORMULANAME C=NOTE L="备注";

#==============================================================
# Table: MIX_BALANCE
#==============================================================
CreateTble C=MIX_BALANCE N="MIX_BALANCE(称)"
(
C=ID T=INT P=Yes M=Yes N="ID",
C=NAME T=VARCHAR(16) P=No M=Yes N="NAME",
C=NOTE T=VARCHAR(256) P=No M=No N="NOTE"
);

addtbllabl T=MIX_BALANCE L="称定义";

#==============================================================
# Table: MIX_BIN
#==============================================================
CreateTble C=MIX_BIN N="MIX_BIN(料仓)"
(
C=ID T=INT P=Yes M=Yes N="ID",
C=NAME T=VARCHAR(16) P=No M=No N="NAME",
C=TYPE T=INT P=No M=Yes N="TYPE" D=0 A=0 B=3
);

addtbllabl T=MIX_BIN L="料仓";

addcollabl T=MIX_BIN C=TYPE L="类型
0:骨料
1:粉料
2:液体
3:水";

#==============================================================
# Table: PRODUCE
#==============================================================
CreateTble C=PRODUCE N="PRODUCE(生产表)"
(
C=ID T=INT P=Yes M=Yes N="ID",
C=BATCHNO T=VARCHAR(32) P=No M=Yes N="BATCHNO",
C=FORMULAID T=INT P=No M=Yes N="FORMULAID",
C=PLANCUBIC T=DOUBLE P=No M=Yes N="PLANCUBIC",
C=ACTUALCUNBIC T=DOUBLE P=No M=Yes N="ACTUALCUNBIC",
C=PRODUCEDATE T=DATE P=No M=Yes N="PRODUCEDATE"
);

addtbllabl T=PRODUCE L="配料纪录表";

addcollabl T=PRODUCE C=BATCHNO L="批次号";

addcollabl T=PRODUCE C=FORMULAID L="所用配方";

addcollabl T=PRODUCE C=PLANCUBIC L="计划方量";

addcollabl T=PRODUCE C=ACTUALCUNBIC L="实际方量";

addcollabl T=PRODUCE C=PRODUCEDATE L="生产日期";

CreateJoin C=FK_FORMULA_REFERENCE_FORMULAN T=FORMULA P=FORMULANAME D=restrict U=restrict
(
P=ID F=NAMEID
);

CreateJoin C=FK_FORMULA_REFERENCE_MIX_BIN T=FORMULA P=MIX_BIN D=restrict U=restrict
(
P=ID F=BINID
);

CreateJoin C=FK_PRODUCE_REFERENCE_FORMULAN T=PRODUCE P=FORMULANAME D=restrict U=restrict
(
P=ID F=FORMULAID
);

请问access2000在那个界面或工具中执行这些脚本？

[changechange]

因为不是 ACCESS 2000 脚本，因此 ACCESS2000 根本无法执行。

[cqjiang]

请问changechange(access911 & cg1)，下面的脚本算不算ACCESS的脚本，标准的SQL语句。
谢谢！

/*==============================================================*/
/* Database name: MixDB */
/* DBMS name: Microsoft Access 2000 */
/* Created on: 2004-3-29 20:45:10 */
/*==============================================================*/


alter table FORMULA
drop constraint FK_FORMULA_REFERENCE_FORMULAN;

alter table FORMULA
drop constraint FK_FORMULA_REFERENCE_BIN;

alter table PRODUCE
drop constraint FK_PRODUCE_REFERENCE_FORMULAN;

drop table BALANCE;

drop table BIN;

drop table FORMULA;

drop table FORMULANAME;

drop table PRODUCE;

/*==============================================================*/
/* Table: BALANCE */
/*==============================================================*/
create table BALANCE
(
ID INT not null,
NAME VARCHAR(16) not null,
NOTE VARCHAR(256)
);

/*==============================================================*/
/* Table: BIN */
/*==============================================================*/
create table BIN
(
ID INT not null,
NAME VARCHAR(16),
TYPE INT not null
);

/*==============================================================*/
/* Table: FORMULA */
/*==============================================================*/
create table FORMULA
(
NAMEID INT not null,
BINID INT not null,
WEIGHT DOUBLE not null
);

/*==============================================================*/
/* Table: FORMULANAME */
/*==============================================================*/
create table FORMULANAME
(
ID INT not null,
NAME VARCHAR(32) not null,
AUTHOR VARCHAR(12),
MODIFYDATE DATE not null,
CREATEDATE DATE not null,
NOTE VARCHAR(256)
);

/*==============================================================*/
/* Table: PRODUCE */
/*==============================================================*/
create table PRODUCE
(
ID INT not null,
BATCHNO VARCHAR(32) not null,
FORMULAID INT not null,
PLANCUBIC DOUBLE not null,
ACTUALCUNBIC DOUBLE not null,
PRODUCEDATE DATE not null
);

alter table FORMULA
add constraint FK_FORMULA_REFERENCE_FORMULAN foreign key (NAMEID)
references FORMULANAME (ID);

alter table FORMULA
add constraint FK_FORMULA_REFERENCE_BIN foreign key (BINID)
references BIN (ID);

alter table PRODUCE
add constraint FK_PRODUCE_REFERENCE_FORMULAN foreign key (FORMULAID)
references FORMULANAME (ID);

[cqjiang]

但是同样不能执行! 为什么?????