Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

General: Some common Access specifications

Author(s)
Dev Ashish

For Access 2002, if you have it installed under "C\program files", click this link.

For Access 97:

Database (.mdb) file size    1 gigabyte.
However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.

Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table  255
Number of characters in a Text field 255
Number of characters in a Memo field

65,535 when entering data through the user interface;
1gigabyte when entering data programmatically.

Form or report width 22 in. (55.87 cm)                            
Section height  22 in. (55.87 cm)                           
Height of all sections plus section headers (in Design view)  200 in. (508 cm)                            
Number of levels of nested forms or reports 3
Number of fields or expressions you can sort or group on in a report  10
Number of controls and sections you can add over the lifetime of the form or report   754

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer