06-30-2009, 10:22 AM #10 Banana split with a cherry atop. Advertisements Latest Threads Dishonored 2: release date Abarbarian posted Sep 29, 2016 at 6:01 PM Amazon, Google, Facebook, IBM and Microsoft form 'Partnership on AI' Becky posted Sep 29, 2016 at Syntax Error In Update Statement If so please flag as an answer. –HarveyFrench Oct 5 '15 at 8:11 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using

This documentation is archived and is not being maintained. I'm trying to access 2 tables. So, while the > following will work: > > currentdb.Execute "update tblCustomers set City = 'New York' where city = > 'NY'" > > This one will not: > currentdb.Execute "CREATE Get More Info Here is some code that I created messing around with this a little this afternoon.

Attempting to apply this restriction more than once results in a run-time error. AlbertKallalView Member Profile Jan 15 2010, 09:10 AM Post#5UtterAccess VIPPosts: 2,362Joined: 12-April 07From: Edmonton, Alberta CanadaAccess does support the data definition SQL create view. Join them; it only takes a minute: Sign up Attempting CREATE VIEW in Access gives “Syntax error in CREATE TABLE statement” up vote 1 down vote favorite I typed this code asked 2 years ago viewed 660 times active 2 years ago Linked 1 Syntax error in CREATE TABLE statement when i am creating procedure Related 0Having Syntax errors Joining 3 tables0SQL

size The field size in characters (Text and Binary fields only). Office button->access options->object designers-> SQL server compatible syntax (ANSI 92) [x] - This database [ ] - Default for new databases HAs mentioned I want to stress to not use this The command we are using is: CREATE VIEW Test1 AS Select * FROM Book; Guest, Sep 27, 2005 #1 Advertisements Albert D.Kallal Guest You can't use the interface to execute As to why we would do this, it was called for in the DBMS course I am taking.

Does anyone know why? You can use ms-access with MySql, and till very recently, you did not have the create view feature (I don't know if it is implemented yet). Does anyone know why I am getting a "Syntax error in Create Table statement". Banana View Public Profile Find More Posts by Banana 06-30-2009, 08:44 AM #7 ByteMyzer AWF VIP Join Date: May 2004 Location: United States Posts: 1,358