FILE: Microsoft Access 2.0 Specs and Limitations for VB 3.0 (115143)

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