SQL errors for ENUM and INDEX

[Greg]

Hi,

I'm new to access and am trying to create DDL queries to setup some of
my tables. I have hit 2 issues that I need help with where access is
giving an error on the sql. The first problem is caused by a statement
similar to below, Access gives an error on the line with the ENUM
datatype for the adult_type column:

create table adults (
adult_id INT(11) NOT NULL
, primary_name VARCHAR(30) NOT NULL
, adult_type NOT NULL ENUM('PARENT','STAFF','OTHER')
, PRIMARY KEY (adult_id)
, UNIQUE (adult_id)
);

The second problem is caused by a statement similae to below, Access
gives an error on the line with the INDEX on the adult_id column.

create table CHILDREN (
child_id INT(11) NOT NULL
, name VARCHAR(30) NOT NULL
, adult_id INT(11) NOT NULL
, PRIMARY KEY (child_id)
, UNIQUE (child_id)
, INDEX children_N1 (adult_id)
);

Any help is getting these two statements to work in access is much
appreciated. FYI, for the INDEX problem I have been able to get it to
work in a separate CREATE INDEX statement but would really prefer to
have it part of the inital DDL query if possible.

Thanks,
Greg