"Syntax error in CREATE TABLE"

[complexcodes]

I am trying to work on VIEW command of SQL. Whenever I write the SQL as

CREATE VIEW PartOrder AS
SELECT PartNum, NumOrdered, price
FROM part;

I get an error message "Syntax error in CREATE TABLE".
I dont have any problems in writing SQL commands but whenever I mention CREATE word, I get the same mesage. I am using office access 2007. Do you guys think I need to do anything before I make this CREATE VIEW thing to work?

Thanks,

[timothybard]

As far as I know, you are able to create Make-Table queries in MS Access, but not Create View queries. Therefore, you can try something like this:

SELECT PartNum, NumOrdered, price INTO PartOrder 
FROM part;