Create a Query from VB6 and store it in DB (Acs 2003) - Runtime

[VBFnewcomer]

I tried to run the below code

conn.Execute "CREATE VIEW QryFromVB AS SELECT fName, mName, lName, DOB From CounselMaster ORDER BY fName;"

I got error Only simple SELECT queries are allowed in VIEWS what does this mean how do I make a query which has sorted data.