FILE: Microsoft Access 2.0 Specs & Limitations for VB 3.0

ID: Q115143

The information in this article applies to:

Microsoft Visual Basic Standard and Professional Editions for Windows, version 3.0
Microsoft Access 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:

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:

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

Comlyr.exe

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

Q119591 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

Additional query words: specs spec limit limits limitations 3.00 softlib

Keywords : kbref kbDocs
Version : 3.00
Platform : WINDOWS
Issue type :