Long Integer?

[George Hester]

I have noticed that Access Help uses a "User-Fiendly" method to refer to
DataTypes in Access 2000. This makes it hard to set datatypes for Fields
when Creating Tables with SQL using the DataTypeEnum constants. So can
anyone tell me what is the DataTypeEnum for Long Integer. I can only find
adInteger which I am sure is not Long. Thanks.

 

[George Hester]

OH ok. Thanks for a little code there. That helps alot.

 

[George Hester]

Ha well there you go. Thanks for that info.

--
George Hester
_________________________________

adInteger is 4 bytes, so it's equivalent to a long data type. Compare that
to adBigInt (8 bytes), adSmallInt (2 bytes), and adTinyInt (1 byte).

Chris
Microsoft MVP