IDENTITY

[Man Utd]

CREATE TABLE [Categories]
([Categories ID] INTEGER IDENTITY,
[Title] TEXT(30),
[System] LOGICAL
)

I got a syntax error when try to save this query in Access 2003.

 

[Wolfgang Kais]

CREATE TABLE [Categories]
([Categories ID] INTEGER IDENTITY,
[Title] TEXT(30),
[System] LOGICAL
)
I got a syntax error when try to save this query in Access 2003.

Hello "Man Utd".
Try the following:
CREATE TABLE [Categories]
( [Categories ID] AUTOINCREMENT,
[Title] TEXT(30),
[System] LOGICAL)

 

[peregenem]

CREATE TABLE [Categories]
([Categories ID] INTEGER IDENTITY,
[Title] TEXT(30),
[System] LOGICAL
)

I got a syntax error when try to save this query in Access 2003.

About ANSI SQL query mode
http://office.microsoft.com/en-us/assistance/HP030704831033.aspx