"CREATE VIEW" command in SQL?

Question

I have an Access Database and want to create a view. When I try it, I get the error message "Syntax error in CREATE TABLE ", although the help file says Access supports the CREATE VIEW command.
Just to check it, I used a very simple command: "CREATE VIEW activityView AS SELECT * FROM activity;", but Access wouldn't do it, not from the Query window, and not with DoCmd.RunSQL from a VBA procedure. How can I do it?

CREATE VIEW filteredActivity(*)... doesn't work either, just tried it

Answer 1

You should list all columns (fields), for example:

CREATE VIEW activityView(a,b,c,...) AS SELECT * FROM activity

Answer 2

The problem is u have to declare arguments for the view...

(eg)

create view mgr(*) as
select * from employee,manages
where employee.name=manages.mgrname;