Why does this cause "Syntax error in CREATE TABLE statement" error?

Question

CREATE TABLE customers (
ID int(4),
Name varchar(20),
Age int(2),
PRIMARY KEY(ID)
);

I'm using MS Access

Answer 1

As seen here (https://www.w3schools.com/sql/sql_primarykey.asp) that format is for mySQL.
try this instead:
CREATE TABLE customers (
ID int(4) NOT NULL PRIMARY KEY,
Name varchar(20),
Age int(2)
);

Answer 2

Kyle Jones It still gives the same error 😐