Knowledge Base

MS Access Version 1.1 Specifications & Limitations for VB 3.0

PSS ID Number: 113440

Article Last Modified on 10/29/2003


The information in this article applies to:


This article was previously published under Q113440

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: KB113440
Technology: kbAudDeveloper kbVB300 kbVB300Search kbVBSearch kbZNotKeyword2 kbZNotKeyword6