How can I get 32-bit Integers?

[Renny Bosch]

I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so as
to have 32-bit Integers, along with 64-bit Longs?

 

[Paul Shapiro]

I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so
as to have 32-bit Integers, along with 64-bit Longs?

An Access Integer is 16 bits. A Long Integer is 32 bits. Access does not
have a 64-bit integer data type.

 

[Arvin Meyer [MVP]]

Perhaps the nomenclature is different, but an Integer is 2 bytes with
values: -32,768 to 32,767. Longs are 4 bytes with values: -2,147,483,648 to
2,147,483,647

 

[De Jager]

I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so
as to have 32-bit Integers, along with 64-bit Longs?