911 questions
Try this command: alter table Blah alter column colm smallint.
Make sure that the rows do not contain large numbers.
Integer equivalent in Access
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
StewartBW
1,805
Reputation points
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
Microsoft 365 and Office Access Development
Developer technologies VB
2,892 questions
Developer technologies C#
11,568 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout 1,861 Reputation points MVP Volunteer Moderator2024-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:
Sign in to comment
Accepted answer
-
Viorel 122.5K Reputation points2024-05-26T15:06:40.42+00:00 -
StewartBW 1,805 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 122.5K Reputation points
2024-05-26T16:41:36.23+00:00 I saw that
smallintresults in Number (Field Size: Integer) datatype in Access.The
integergives Number (Field Size: Long Integer). -
StewartBW 1,805 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 -