DAO(使用Diamond1.90)能够创建ACCESS视图吗?(100分)

DAO(使用Diamond1.90)能够创建ACCESS视图吗?
daoquery1.Close;
daoquery1.SQL.clear;
daoquery1.SQL.Add('create view sfg123 as select * from letters');
daoquery1.Execute(0);
出现Create Table 语句中的语法错误???????

DAO好像不行，据说ADO可以，用ADOStoredProc。但我也不会用，你自己试试吧。

用dao的querydef来做 ，create view msaccess97不支持
以下是vb的例子
Dim dbs As Database, qdf As QueryDef
Dim strSQL As String
' Return reference to current database.
Set dbs = CurrentDb
' Refresh QueryDefs collection.
dbs.QueryDefs.Refresh
' If RecentHires query exists, delete it.
For Each qdf In dbs.QueryDefs
If qdf.Name = "RecentHires" Then
dbs.QueryDefs.Delete qdf.Name
End If
Next qdf
' Create SQL string to select employees hired on or after 1-1-94.

strSQL = "SELECT * FROM 关键字表 "
' Create new QueryDef object.
Set qdf = dbs.CreateQueryDef("关键字视图", strSQL)
' Open query in Datasheet view.
DoCmd.OpenQuery qdf.Name
Set dbs = Nothing

看样DIMAOND是不能了,我用ADO是可以的,但不知DAO应该怎样做?
有DELPHI的示例吗?

ADO可以？ACCESS只有QueryDef对象，没有View的
Dao可以创建QueryDef，ADO不能创建QueryDef，
AdoX可以。

acess not support view
you can use querydef instand of it
view is the result of some select clause
you can use some select clause instant of view

多人接受答案了。