Integer types under Jet 4.0

  • Thread starter Thread starter John Dann
  • Start date Start date
J

John Dann

If I'm creating a database from ado.net to be accessed via Jet 4.0,
where can I find a list of valid field types? I'm specifically
interested in the range of integer types available. I'll have a lot of
data that would fit into Int16 and it could (pesumably) save me a
significant amount of space in the final database to use Int16 rather
than eg Int32. But is Int16 a valid field type in Jet 4.0 table
definitions?

JGD
 
¤ If I'm creating a database from ado.net to be accessed via Jet 4.0,
¤ where can I find a list of valid field types? I'm specifically
¤ interested in the range of integer types available. I'll have a lot of
¤ data that would fit into Int16 and it could (pesumably) save me a
¤ significant amount of space in the final database to use Int16 rather
¤ than eg Int32. But is Int16 a valid field type in Jet 4.0 table
¤ definitions?

Microsoft Access Number data types support both Integer (16-bit) and Long (32-bit).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top