Creating Access Table error?

[JohnStep]

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 CHAR(20), SSN CHAR (9), PrevAddress CHAR(50), PrevCity CHAR (50), PrevZip CHAR(5), State INT, CarMake CHAR(50), CarModel CHAR (50), CarColor CHAR(50), CarLicense CHAR(25), CarState INT, Employer CHAR(50), EmployerPhone CHAR(20), OtherOccupants CHAR(100), Rent_Due (DATE), Last_Paid (DATE), Next_Due (DATE), Late_Pay (INT), Amount_Paid (CURRENCY), Amount_Due (CURRENCY);"


Thanks in Advaced

 

[fredericofonseca]

DATE and currency are data types so remove the () around them.

And there is one ")" missing at the end of the columns definitions.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[gmmastros]

I thought that 'string' fields in Access are actually Text (not char).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[JohnStep]

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 CHAR(50), CarModel CHAR (50), CarColor CHAR(50), CarLicense CHAR(25), CarState INT, Employer CHAR(50), EmployerPhone CHAR(20), OtherOccupants MEMO, RentDue DATE, LastPaid DATE, NextDue DATE, LatePay INT, AmountPaid CURRENCY, AmountDue CURRENCY);"


and it works fine! Thanks again!