Article ID: 115143 - Last Review: August 31, 2005 - Revision: 3.3

FILE: Microsoft Access 2.0 Specs and Limitations for VB 3.0

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q115143

On This Page

Expand all | Collapse all

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.
Back to the top

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:

  • Microsoft Visual Basic version 3.0
  • Microsoft Access version 2.0
  • Microsoft Jet 2.0/Visual Basic 3.0 Compatibility Layer
Back to the top

How to Obtain the Compatibility Layer

To obtain the Compatibility Layer, choose one of the following methods:
  • Download the Compatibility Layer from the Microsoft Download Center: The following file is available for download from the Microsoft Download Center:
    Comlyr.exe (http://download.microsoft.com/download/access20/doc/1/win98/en-us/comlyr.exe)
    For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
    119591  (http://support.microsoft.com/kb/119591/EN-US/ ) How to Obtain Microsoft Support Files from Online Services
    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
  • 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/ (http://www.microsoft.com/worldwide/)
  • 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.
Back to the top

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.
Back to the top

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
Back to the top

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
Back to the top
APPLIES TO
  • Microsoft Visual Basic 3.0 Professional Edition
  • Microsoft Visual Basic 3.0 Professional Edition
  • Microsoft Access 2.0 Standard Edition
Back to the top
Keywords: 
kbdownload kbdocs kbfile kbinfo kbref KB115143
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top