Microsoft KB Archive/115143

= FILE: Microsoft Access 2.0 Specs and Limitations for VB 3.0 =

Article ID: 115143

Article Last Modified on 8/31/2005

-

APPLIES TO


 * Microsoft Visual Basic 3.0 Professional Edition
 * Microsoft Visual Basic 3.0 Professional Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q115143



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:


 * Microsoft Visual Basic version 3.0
 * Microsoft Access version 2.0
 * Microsoft Jet 2.0/Visual Basic 3.0 Compatibility Layer

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

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 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/ 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

Additional query words: specs spec limit limits limitations 3.00

Keywords: kbinfo kbdownload kbref kbfile kbdocs KB115143

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.