ALTER TABLE ADD Column - datatypes

[Edski]

Does anyone know how to add a new field of type Integer to a table in Access using the ALTER TABLE syntax?

Db.Execute "ALTER TABLE MyTable ADD COLUMN myField Integer"

works but adds a field of type Long Integer.

 

[JerryKlmns]

Db.Execute "ALTER TABLE MyTable ADD COLUMN myField SMALLINT"

Keep this handy

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

 

[Edski]

Doh! ...Thanks.
Nice hyperlink by the way.

 

[JerryKlmns]

Yeah! And do study also the Fundamental & Advanced links mentioned at the bottom