FILE: Microsoft Access 2.0 Specs & Limitations for VB 3.0

ID: Q115143

3.00 WINDOWS kbref kbfile

The information in this article applies to:

- Standard and Professional Editions of Microsoft Visual Basic 

  Programming System for Windows, version 3.0
- Microsoft Access, version 2.0

SUMMARY

This article lists the Microsoft Access version 2.0 Specifications from Appendix A of the Microsoft Access User's Guide. It is provided here for the benefit of Visual Basic programmers.

MORE INFORMATION

This information applies only to Microsoft Access version 2.0 (Jet 2.0) databases. Therefore, for this information to be useful, you need to own all three of these products:

How to Obtain the Compatibility Layer

To obtain the Compatibility Layer, choose one of the following methods:

The following file is available for download from the Microsoft Software Library: 

 ~ Comlyr.exe (size: 741798 bytes)
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from
               Online Services
  • If you are unable to access the source listed above, you can have Comlyr.exe mailed or faxed to you by calling Microsoft Technical Support Monday through Friday, 6:00 a.m. to 6:00 p.m. Pacific time at (425) 646-5105. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, go to the Microsoft Web site http://www.microsoft.com/worldwide/default.htm
  • Purchase the Microsoft Access Developer's Toolkit (ADT) version 2.0 available through resellers or direct from Microsoft.
  • Purchase the Microsoft Office Developer's Kit (ODK). The ODK will be available as a standard component in all new packages of Visual Basic version 3.0 Professional Edition. The ODK comes on CD-ROM only.

    Microsoft Access 2.0 Databases

       Attribute                                                Maximum
   -------------------------------------------------------------------
   .MDB file size                                           1 gigabyte
   Number of objects in a database                          32,768
   Number of characters in object names                     64
   Number of characters in a password                       14
   Number of characters in a user name or group name        20
   Number of concurrent users                               255

   NOTE:  Because your database can include attached tables in other
          files, its total size is limited only by available storage
          capacity.

    Microsoft Access 2.0 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                     64,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 validation rule                2048
   Number of characters in a table or field description     255
   Number of characters in a record                         2000
     (Excluding Memo and OLE Object fields)
   Number of characters in a field property                 255

    Microsoft Access 2.0 Queries

       Attribute                                                Maximum
   -------------------------------------------------------------------
   Number of tables in a query                              32
   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 in the QBE grid           255
   Number of ANDs in a WHERE or HAVING clause               40
   Number of characters in an SQL statement                 64,000
    KBCategory: kbref kbfile KBSubcategory: RefsProd RefsDoc Additional reference words: specs spec limit limits limitations 3.00 softlib 
    Keywords          : kbref kbDocs 
Version           : 3.00
Platform          : WINDOWS

    Last Reviewed: October 23, 1997