1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Microsoft Works Database

Discussion in 'All Other Software' started by debodun, Nov 2, 2009.

Thread Status:
Not open for further replies.
  1. debodun

    debodun Thread Starter

    Joined:
    Jun 12, 2004
    Messages:
    589
    Does anyone know how many record entries (not fields) are possible in a MWDB file? I was working on an inventory list when suddenly the database would not accept any more entries. I didn't know if the was a limit. Is there any database that has no limit as to entries?
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,181
    First Name:
    Wayne
    I know microsoft access 2003 used to be a file size limit of 2GB - so would not expect works to be bigger (although, not yet found the spec)

    Whats the filesize you currently have?
     
  3. debodun

    debodun Thread Starter

    Joined:
    Jun 12, 2004
    Messages:
    589
    After a little searching, I found this data which indicates that only 32,000 records can be entered. There's my answer, but thanks for your input.

    :
    Maximum Limits for Database

    File size No physical limit
    Concurrent fonts 510 in list view
    510 in form view
    510 in report view
    Concurrent styles 1 per field
    Records per file 32,000
    Fields per record 256
    Characters per record 35,500
    Characters per field 2047
    Characters per printed line 255 (6 reserved for row label)
    Characters per field name 15
    Field width in list view 0-256
    Column width in report view: 1-256
    Field width in form view: 0-325
    (depending on font size)
    Field height in form view: 0-325
    (depending on font and page size)
    Decimal accuracy 15
    Sorting levels 3
    Concurrent sorting levels 3
    Nested control breaks 3
    (break fields)
    Reports per file 8
    Filters per file 8
    Number of pages in form view 3
    Form size 22 inches square
    Date range 1/1/1900 - 6/3/2079 (anything outside
    this range is treated as text)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/873748

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice