Limitations and Data Types
Maximum number of rows - 2,147,483,647.
Maximum number of columns - 1,024.
The following table lists Updateable Data
Types.
These are Field Data Types that can be updated
directly in the grid.
|
ADO |
DAO |
| adBigInt | dbBigInt |
| adBoolean | dbBoolean |
| adChar | dbByte |
| adCurrency | dbCurrency |
| adDate | dbDate |
| adDBDate | dbDecimal |
| adDBTime | dbDouble |
| adDecimal | dbFloat |
| adDouble | dbInteger |
| adInteger | dbLong |
| adNumeric | dbNumeric |
| adSingle | dbText |
| adSmallInt | dbTime |
| adTinyInt | |
| adUnsignedBigInt | |
| adUnsignedInt | |
| adInsignedSmallInt | |
| adUnsignedTinyInt | |
| adVarChar |