Thanks alot for the tips. I edited the field to:
DB.Execute "CREATE TABLE Tennant" & "(BuildingName CHAR (50), Apt INT, FirstName CHAR (50), MiddleInitial CHAR(1), LastName CHAR(50), Phone CHAR(20), SSN CHAR (9), PrevAddress MEMO, PrevCity CHAR (50), PrevZip CHAR(5), State INT, CarMake...