IDENTITY

M

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.
 
W

Wolfgang Kais

Man Utd said:
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.
Click to expand...

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