Microsoft KB Archive/29084

Record Size Specifications in a Works Database

PSS ID Number: Q29084 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

The Database module in versions 1.0, 1.05, and 2.0 of Microsoft Works for MS-DOS resides in memory. The maximum size of a database is 4,096 records by 256 fields. The maximum size of a field is 255 characters. For a computer with 640K of RAM, the practical limit for the size of a database in these versions is approximately 2,000 records with eight fields each. In Works version 2.0, you can add up to 4 MB of expanded memory (EMS) to work with larger databases and spreadsheets.

In Works version 3.0, the Database module is disk-based and the maximum size of both a database and spreadsheet is larger. The number of fields and characters per field is the same; however, the number of records allowed in a database is now 32,000, and the number of rows in a spreadsheet is now 16,384. Because the Spreadsheet module in Works 3.0 is not disk based, you will need to add expanded memory to work with larger Spreadsheet files.

NOTE: The Database module in Works versions 1.x, 2.0, and 3.0 is nonrelational.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 2.00 3.00 LIM max limits non-relational =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.