I'm trying to create a table in a Access DB using the following line, but it's giving me a Syntax error. For the life of me I cannot find it.
Any Ideas?
db.Execute "CREATE TABLE Tennant" & "(BuildingName CHAR (50), Apt INT, FirstName CHAR (50), MiddleInitial CHAR(1), LastName CHAR(50), Phone...