I am using Access for the first time in a class. I used a template from another site and wrote one on my own. These are really simple and I can't figure out why the one I wrote won't work. All it is a simple "Create Table" script. Every time I try to RUN the script I get a "Syntax error in field definition error." I have been trying and trying but can't for the life of me figure out the problem. The template I used that works looks like:
CREATE TABLE Author
(
AuthorId int,
LastName varchar(255),
FirstName varchar(255),
Genre varchar(255)
)
The one I wrote that does not work looks like this:
CREATE TABLE Authors
(
AuthorId int,
AuthorFirstName varchar(255),
AuthorLastName varchar(255),
Genre varchar(255),
)