Jump to content

Creating Views in Access?


Recommended Posts

Hi, I'm new to this forum.. I was checking out the little tutorial here on SQL.. I used to use it all the time 4 years ago, but I'm a little rusty so I'm oiling the joints so to speak.. (says tinman!) Anyway, the end of the advanced section mentions creating views in the Northwind database. So I opened up Nortwind in my trusty Access and tried running the SQL query: CREATE VIEW [Current Product List] ASSELECT ProductID,ProductNameFROM ProductsWHERE Discontinued=NoSeems simple enough.. but I get an error: "Syntax error in CREATE TABLE statement." does Access allow you to create views? Or am I jest a little too far behind the eight ball?Jeff

Link to post
Share on other sites
As far as I know, it's not possible... But I was not sure so I have just tried it, and Access gave me the same error as you... you should better use something like sql server

Yeah... geez! you'd think MS would want to standardize the use of SQL, woudn't you? When I look at some of its "wizard" driven SQL statements they look terrible! (sigh!) well.. for now I don't have SQL server at home... so I guess I'll have to wait till I get acess to it. :)
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...