Integer equivalent in Access

StewartBW 1,145

Hello

I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so:

Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???", connection)
cmd.ExecuteNonQuery

Please advise what to write instead of ??? to set to Int32 , shows as Integer in Access.

Thanks

Tom van Stiphout 1,696 Reputation points MVP

2024-05-26T17:39:55.2933333+00:00

Coming from a .NET perspective, when you say "Integer" you typically mean Int32: a 32-bit integer between -2 billion and +2 billion (give or take).
The equivalent in Access is a Number data type, with Long Integer subtype. It can store integers in the same number range.
So I would first try "integer" for ??? and then inspect the table design in Access to make sure the correct subtype (Field Size) was selected.

Example:

Accepted answer

Viorel 118K Reputation points

2024-05-26T15:06:40.42+00:00

Try this command: alter table Blah alter column colm smallint.

Make sure that the rows do not contain large numbers.
Please sign in to rate this answer.

1 person found this answer helpful.
StewartBW 1,145 Reputation points

2024-05-26T16:15:31.7566667+00:00

Hello,

Thanks bro, SMALLINT converts to Byte in Access.

I was testing some values blindly and found that SHORT will translate to Integer in Access, can you please confirm?

Viorel 118K Reputation points

2024-05-26T16:41:36.23+00:00

I saw that smallint results in Number (Field Size: Integer) datatype in Access.

The integer gives Number (Field Size: Long Integer).

StewartBW 1,145 Reputation points

2024-05-26T21:34:26.96+00:00

oops my bad, yes, both SHORT and SMALLINT seems to be same:

https://learn.microsoft.com/en-us/office/vba/access/concepts/error-codes/comparison-of-data-types

SHORT (See Notes)

(Synonyms: INTEGER2, SMALLINT)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer