Adding column as INTEGER makes it a long integer?

[luckycharms]

Hi Folks,



I'm using the code below in access 2007. The field ends up being a long integer! What's up with that? Shouldn't INTEGER be an integer, and a LONG be a long?

If Not FieldExists("Dosel", "BlockID") Then
        dbs.Execute "ALTER TABLE Dosel ADD COLUMN BlockID INTEGER;", dbFailOnError
End If

[weekend00]

if you want 16-bit integer, it's called short, not integer.:
ALTER TABLE Dosel ADD COLUMN BlockID short;

[luckycharms]

awesome - thanks.