PSS ID Number: 113440
Article Last Modified on 10/29/2003
Attribute Maximum ------------------------------------------------------------------- .MDB file size 1 gigabyte Number of tables in a database 32,768 Number of attached tables in a database 32,768 Number of queries in a database 32,768 Number of open tables 254 Number of characters in object Names 64 Number of characters in password 14 Number of characters in user name or group name 20 Number of concurrent users 255
Attribute Maximum ------------------------------------------------------------------- Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a record or table 255 Table size 1 gigabyte Number of characters in a text field 255 Number of characters in a memo field 32,000 Size of OLE Object field 1 gigabyte Number of indexes in a record or table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a table of field description 255
Attribute Maximum ------------------------------------------------------------------- Number of tables in a query 16 Number of fields in a dynaset 255 Dynaset size 1 gigabyte Number of sorted fields in a query 10 Number of levels of nested queries 50 Number of characters in a cell 255 Number of ANDs in a WHERE or HAVING clause 40
Additional query words: specs spec limit limits limitations 3.00
Keywords: KB113440
Technology: kbAudDeveloper kbVB300 kbVB300Search kbVBSearch kbZNotKeyword2 kbZNotKeyword6