What are the limits for Pocket Access databases and ADOCE?
Under Windows CE 2.1x devices: • max record size128K • max Database file size 16MB • max fields countno limit • max prop size64K • max sort order4 • max number of objects64K Note, an object can be thought of as a chunk of data in the object store or in a database volume. These are some of the different kinds of objects: • Registry key or value (obj store only) • Directory (obj store only) • File header (obj store only) • Data block – up to 4kB of file data, or up to 4kB of a database record • Database header Under Windows CE 3.0 devices the limits for 3.0 are the same as listed above, with the exception of the last one. One table in a database file is limited to 64k records, but a database file in general can have more (by having more than one table in it). The maximum number of objects (records, tables, 4k chunks of property data) is 4096*1024=approx.
