MS Access Version 1.1 Specifications & Limitations for VB 3.0
ID: Q113440
|
The information in this article applies to:
-
Microsoft Visual Basic Standard and Professional Editions for Windows, version 3.0
SUMMARY
This article lists the Microsoft Access version 1.1 Specifications from
Appendix A of the Microsoft Access User's Guide. We are providing it
here for the benefit of Visual Basic programmers.
MORE INFORMATION
Database
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
Tables
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
Queries
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 :
Version : WINDOWS:3.0
Platform : WINDOWS
Issue type :