HELP: Why EXcute() of CDaodatabase does not work with "CREATE TABLE" sql

[genliu777]

Using CDaodatabase and CDaoRecordset to work with Sql2000 personal.

sql = _T("SELECT * INTO YOU FROM MY WHERE 1=2");
db.Execute(sql);

Excute() is doing well with copying a table, but

sql = _T("CREATE TABLE THEY (DATES Long NOT NULL PRIMARY KEY,CROSS Long NULL);");
db.Execute(sql);

Excute( ) does not work!!! it does not work with "CREATE TABLE" sql!!!!

Why??