CREATE VIEW by ADO SQL statement

From: Evgeny Zoldin (zoldin_at_hotmail.com)
Date: 02/28/04

Date: Sat, 28 Feb 2004 13:54:30 +0100

Hi ALL.

I tried to create Query object in Access-2000 MDB file by means of ADO API:

conn - opened ADO.Connection object. I called

conn.Execute("CREATE VIEW v1 AS SELECT f1, f2, f3 FROM t1 ORDER BY f1
DESC;")

and obtained error:

-2147467259: Only simple SELECT queries are allowed in VIEWS.

But call

conn.Execute("CREATE VIEW v1 AS SELECT f1, f2, f3 FROM t1;")

works fine. Actually I already have query with fields f1 and f2 and just
want to append the 3rd f3. And I must to do it by ADO mechanism only.

I will be appreciated for any help.

Evgeny