A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Syntax error in CREATE TABLE statement. (Error 3290)



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 04:44 PM posted to microsoft.public.access.queries
zufie
external usenet poster
 
Posts: 70
Default Syntax error in CREATE TABLE statement. (Error 3290)

I am trying to Create a table from DDL code.

Upon running the query I get the error: Syntax error in CREATE TABLE
statement. (Error 3290)

Here is my code after making many changes to it:

CREATE TABLE ACCOUNTABILITY (
OBJECTID number (22) NOT NULL,
OBJECTOWNERID decimal (22),
COMMISOID decimal (22),
RESPONOID decimal (22),
COMMISOBJECTTYPE CHARACTER (5),
RESPONOBJECTTYPE CHARACTER (5),
ACCOUNTYPEOID decimal (22),
BEGINDATE TIMESTAMP,
ENDDATE TIMESTAMP,
OBJECTTYPE CHARACTER (5),
ACL decimal (22),
REPLICNUMBER INTEGER,
ROWLASTCHANGE TIMESTAMP NOT NULL)
;

Any suggestions? I am all ears and eyes.

Zuf
  #2  
Old May 24th, 2010, 04:56 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 7,815
Default Syntax error in CREATE TABLE statement. (Error 3290)

Are you trying to create this table in JET table or an ACE table (the "native"
Access databases?

If so, check out

For a list of the names to use for the field types, see:
Field type names (JET, DDL, DAO and ADOX)
at:
http://allenbrowne.com/ser-49.html

For instance
COMMISOBJECTTYPE Text(5)
BeginDate DateTime
EndDate DateTime

By the way TIMESTAMP is not a date or time field.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

zufie wrote:
I am trying to Create a table from DDL code.

Upon running the query I get the error: Syntax error in CREATE TABLE
statement. (Error 3290)

Here is my code after making many changes to it:

CREATE TABLE ACCOUNTABILITY (
OBJECTID number (22) NOT NULL,
OBJECTOWNERID decimal (22),
COMMISOID decimal (22),
RESPONOID decimal (22),
COMMISOBJECTTYPE CHARACTER (5),
RESPONOBJECTTYPE CHARACTER (5),
ACCOUNTYPEOID decimal (22),
BEGINDATE TIMESTAMP,
ENDDATE TIMESTAMP,
OBJECTTYPE CHARACTER (5),
ACL decimal (22),
REPLICNUMBER INTEGER,
ROWLASTCHANGE TIMESTAMP NOT NULL)
;

Any suggestions? I am all ears and eyes.

Zuf

  #3  
Old May 24th, 2010, 05:11 PM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default Syntax error in CREATE TABLE statement. (Error 3290)

zufie wrote:
I am trying to Create a table from DDL code.

Upon running the query I get the error: Syntax error in CREATE TABLE
statement. (Error 3290)

Here is my code after making many changes to it:

CREATE TABLE ACCOUNTABILITY (
OBJECTID number (22) NOT NULL,
OBJECTOWNERID decimal (22),
COMMISOID decimal (22),
RESPONOID decimal (22),
COMMISOBJECTTYPE CHARACTER (5),
RESPONOBJECTTYPE CHARACTER (5),
ACCOUNTYPEOID decimal (22),
BEGINDATE TIMESTAMP,
ENDDATE TIMESTAMP,
OBJECTTYPE CHARACTER (5),
ACL decimal (22),
REPLICNUMBER INTEGER,
ROWLASTCHANGE TIMESTAMP NOT NULL)
;

Any suggestions? I am all ears and eyes.

Zuf



"number" and "timestamp" are not valid Jet SQL datatypes. Click F1,
click the link to get you to the table of contents, scroll down to the
Jet SQL Reference node, expand it, then expand Overview and select the
Data Types topic. You'll find you should be using "decimal" and
"datetime" respectively.

--
HTH,
Bob Barrows


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.