SQL syntax error in create table statement

Question

I'm just starting out experimenting with SQL on MS Access. I'm trying to insert data into a table, and I can't figure out what I'm doing wrong here. I know it's probably something simple so I apologize in advance. Thanks for any help you can give me!

Here's what I've got:

CREATE TABLE DeathDay
  (
     ID        INT PRIMARY KEY NOT NULL,
     LastName  CHAR(25),
     FirstName CHAR(10),
     DoB       DATE,
     DoD       DATE
  );

INSERT INTO DeathDay
VALUES      (1,
             'Breitenbach',
             'Max',
             '1991-05-17',
             '2022-12-31');

I can create the table fine, but it gives me the following error message when I try to insert the data.

"Syntax error in CREATE TABLE statement"

Are you guessing when someone will die for DoD? Perhaps that's why you're receiving an error. — Kermit
– Kermit, Commented Jan 28, 2013 at 21:23
The delimiter for literal values inserted into date fields is #. Try using #1991-05-17# and #2002-12-31# instead. — Tim Lentine
– Tim Lentine, Commented Jan 28, 2013 at 21:24
I just tested both in MS Access 2010 and received no error. What is the error? — Taryn
– Taryn, Commented Jan 28, 2013 at 21:25

Taryn · Accepted Answer · 2013-01-28 21:28:08Z

3

I just ran your scripts in separate query windows in MS Access 2010 and there was no error. However, if you try running them at the same time, you get an error:

Syntax error in CREATE TABLE statement

Based on my experience you cannot run multiple queries in the same query window.

If you want to run multiple queries then you want to use a script to process it.

answered Jan 28, 2013 at 21:28

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2019632 Over a year ago

That was it, thanks! Thought it might be something obvious like that. Just opened a new query window and it worked. Can I delete old query windows after I've run the commands? It seems like it would get rather cluttered if I keep all the old queries.

Taryn Over a year ago

Yes, you don't need to keep it unless you have reason to.

Ben Alan Over a year ago

In my experience you can't even add multiple records at the same time, let alone queries. ...anything to keep the workday at 40hrs I guess.

majjam · Accepted Answer · 2013-10-17 08:49:54Z

0

In case anyone else comes to this question with the same problem as me, I found the issue to be keywords in my SQL statement. In my case "Currency". A list of reserved keywords is available here: http://allenbrowne.com/AppIssueBadWord.html the ones that are relevant to SQL are the Jet keywords.

answered Oct 17, 2013 at 8:49

majjam

1,3182 gold badges16 silver badges34 bronze badges

Collectives™ on Stack Overflow

SQL syntax error in create table statement

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related